Lesson 1:
Structuring Existing Data

Analyse Tables, Create a Junction Table, Improve Table Structure

Lesson 2:
Writing Advanced Queries

Create Subqueries, Create Unmatched and Duplicate Queries, Group and Summarize Records Using Criteria, Summarize Data Using a Crosstab Query, Create a PivotTable and a PivotChart

Lesson 3:
Simplifying Tasks with Macros

Create a Macro, Attach a Macro, Restrict Records Using a Condition, Validate Data Using a Macro, Automate Data Entry Using a Macro

Lesson 4:
Making Effective Use of Forms

Display a Calendar on a Form, Organize Information with Tab Pages, Display a Summary of Data in a Form

Lesson 5:
Making Reports more Effective

Include a Chart in a Report, Print Data in Columns, Cancel Printing of a Blank Report, Create a Report Snapshot

Lesson 6:
Maintaining an Access Database

Link Tables to External Data Sources, Manage a Database, Determine Object Dependency, Document a Database, Analyse the Performance of a Database