Course Description
This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you’ll master more advanced techniques for this powerful database program and build an entire database project from scratch.
From building reports to using conditional formatting, you’ll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you’ll build a navigation form to make it easy for your users to find their way around your database.
What Will I Learn?
- Design Tables for Better Data Entry
- Share Data with Other Applications
- Work with Action Queries
- Advanced Query Techniques
- Automate Processes with Macros
- Advanced Forms
- Advanced Report Techniques
Requirements
- Access 2016 Introduction or equivalent experience.
Who is the target audience?
- Students who want to take Access to the next level and improve their database design skills.
-
Introduction
00:01:00
-
Reviewing Table Design Principles
00:04:00 -
Setting Field Size, Formats and Captions
00:06:00 -
Setting Default Value and Required Fields
00:03:00 -
Restricting Data Entry Using Data Validation
00:02:00 -
Restricting Data Entry Using Input Masks
00:06:00
-
Exporting Tables and Queries to Excel
00:03:00 -
Importing Data from a TXT File
00:03:00 -
Importing Data from Excel
00:02:00 -
Exporting Data to a TXT File
00:02:00 -
Linking External Data Sources
00:03:00 -
Using Word Merge
00:02:00
-
What are Action Queries
00:02:00 -
Creating an Update Query
00:02:00 -
Creating an Append Query
00:03:00 -
Creating a Delete Query
00:02:00 -
Creating a Make Table Query
00:02:00 -
Changing the Start Number of an Auto Number Field
00:03:00
-
Creating Query Joins
00:05:00 -
Creating Find Unmatached and Find Duplicate Queries
00:03:00 -
Creating Parameter Queries
00:04:00 -
Using -Like- Keyword in Parameter Queries
00:02:00 -
Creating a Top X Query
00:02:00 -
Reviewing Calculated Query Fields
00:03:00 -
Summarizing Query Data with Totals
00:03:00 -
Inserting Where Statements in Summary Queries
00:01:00 -
Creating a Crosstab Query
00:03:00
-
Understanding Macro Basics
00:06:00 -
Creating Macros to Open Forms by Record
00:04:00 -
Validating Data Entry with Macros
00:04:00 -
Creating a Macro to Automate Data Entry
00:03:00 -
Advanced Data Entry Using Macros and DLOOKUP Function
00:06:00
-
Using Conditional Formatting
00:02:00 -
Organizing Form Fields with Tab Controls
00:03:00 -
Creating a Combo Box Control
00:02:00 -
Creating an Option Group Control
00:03:00 -
Using a Subform to Show Data from a Related Table
00:03:00
-
Inserting a Chart on a Report
00:03:00 -
Showing Data in Columns
00:02:00 -
Inserting a Subreport
00:02:00 -
Configuring Reports with Parameter Queries
00:04:00 -
Sending Reports
00:02:00
-
Course Recap
00:01:00
-
Resources – Access 2016 Intermediate
Course Reviews
No Reviews found for this course.