Microsoft® Office Access® 2016
Course Content
Level 1 (1 day)
Lesson 1: Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access
Lesson 2: Working with Table Data
Modify Table Data
Sort and Filter Records
Lesson 3: Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query
Lesson 4: Using Forms
Create Basic Access Forms
Work with Data on Access Forms
Lesson 5: Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports
Level 2 (1 day)
Lesson 1: Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships
Lesson 2: Joining Tables
Create Query Joins
Relate Data Within a Table
Work with Subdatasheets
Lesson 3: Using Data Validation
Use Field Validation
Use Form and Record Validation
Lesson 4: Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries
Lesson 5: Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure
Lesson 6: Using Advanced Reporting Techniques
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report
Level 3 (1 day)
Lesson 1: Implementing Advanced Form Design
Add Controls to Forms
Enhance Navigation and Organization of Forms
Apply Conditional Formatting
Lesson 2: Sharing Data Across Applications
Import Data into Access
Export Access Data
Link Tables to External Data Sources
Create a Mail Merge
Lesson 3: Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 4: Using VBA
Getting Started with VBA
Enhance Access Using VBA
Lesson 5: Using Advanced Database Management
Manage a Database
Determine Object Dependency
Document a Database
Lesson 6: Distributing and Securing a Database
Splitting a Database for Multiple User Access
Implement Security
Convert an Access Database to an ACCDE File
Package a Database with a Digital Signature
Lesson 7: Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options