Lesson 1: Getting Started with Access
- Topic A: What is Microsoft Access?
- Topic B: Components of a Database
- Topic C: Create a Simple Database
- Topic D: Creating a Simple Form
Lesson 2: Working with Table Data
- Topic A: Work with Table Data
- Topic B: Work with Records
- Topic C: Sort and Filter Records
- Topic D: Create Lookups and Relationships
Lesson 3: Query a Database
- Topic A: Use a Query to View Data from Multiple Tables
- Topic B: Sort and Filter Data in a Query
- Topic C: Perform Calculations in a Query
Lesson 4: Create Advanced Queries
- Topic A: Create Parameter Queries
- Topic B: Create Action Queries
- Topic C: Create Find Duplicate and Find Unmatched Queries
- Topic D: Summarize Data
Lesson 5: Generate Reports
- Topic A: Create a Report
- Topic B: Add Controls to a Report
- Topic C: Advanced Reporting
Lesson 6: Design a Relational Database
- Topic A: Relational Database Design
- Topic B: Working with Tables
- Topic C: Modify a Table and Fields
- Topic D: Create Table Relationships
Lesson 7: Joining Tables
- Topic A: Create Query Joins
- Topic B: Working with Subdatasheets and Subqueries
Lesson 8: Importing and Exporting Data
- Topic A: Import Data into Access
- Topic B: Export Data
- Topic C: Create a Mail Merge
