Topic 1

Getting Started with Access

• Microsoft Access 2016
• Database Templates
• Using Tell Me

Topic 2

Working with Table Data

• AutoCorrect
• Adding New Records
• The Sort Feature
• Lookup Fields

Topic 3

Querying a Database

• Query Views
• Query Criteria
• Arithmetic Operators

Topic 4

Creating Advanced Queries

• Parameter Queries
• Action Queries
• The Find Duplicates Query Wizard
• Crosstab Queries

Topic 5

Generating Reports

• Report Creation Tools
• Report Sections
• Galleries
• Adding a Header or Footer

Topic 6

Customizing the Access Environment

• Access Options

Topic 7

Designing a Relational Database

• Relational Databases
• Table Creation Options
• Renaming a Table
• The Relationships Window

Topic 8

Joining Tables

• Query Joins
• Joining Tables with No Common Fields
• Self-Joins
• Subdatasheets
• Subqueries

Topic 9

Organizing a Database for Efficiency

• First Normal Form
• Many-to-Many Relationships

Topic 10

Sharing Data Across Applications

• Data Importing
• Data Exporting
• Exporting Access Data to Excel
• The Microsoft Word Mail Merge Wizard

Topic 11

Advanced Reporting

• Report Design Elements
• Report Format Tools
• Data Bars
• Calculated Fields
• Sub reports

Topic 12

Additional Reporting Options

• The Label Wizard
• Publishing a Report as PDF