| Lesson 1: Getting Started with Access |
Orientation to Microsoft Access
Create a Simple Access Database
Get Help in Microsoft Access |
| Lesson 2: Working with Table Data |
Modify Table Data
Sort and Filter Records
Create Lookups |
| Lesson 3: Querying a Database |
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query |
| Lesson 4: Creating Advanced Queries |
Create Parameter Queries
Create Action Queries
Create Unmatched and Duplicate Queries
Summarize Data |
| Lesson 5: Generating Reports |
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print |
| Lesson 6: Customizing the Access Environment |
| The Access Options Dialog Box |
| Lesson 7: Designing a Relational Database |
Relational Database Design
Create a Table
Create Table Relationships |
| Lesson 8: Joining Tables |
Create Query Joins
Join Tables That Have No Common Fields
Relate Data within a Table
Work with Subdatasheets
Create Subqueries |
| Lesson 9: Organizing a Database for Efficiency |
Data Normalization
Create a Junction Table
Improve Table Structure |
| Lesson 10: Sharing Data Across Applications |
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge |
| Lesson 11: Advanced Reporting |
Organize Report Information
Format Reports
Include Charts in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report |
