You will create complex Access databases using forms, reports, and macros.

Lesson 1: Structuring Existing Data
A: Import Data
B: Analyze Tables
C: Create a Junction Table
D: Improve Table Structure

Lesson 2: Writing Advanced Queries
A: Create Unmatched and Duplicates Queries
B: Group and Summarize Records Using the Criteria Field
C: Summarize Data with a Crosstab Query
D: Create a PivotTable and a PivotChart
E: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
A: Create a Macro
B: Attach a Macro to a Command Button
C: Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros
A: Require Data Entry with a Macro
B: Display a Message Box with a Macro
C: Automate Data Entry

Lesson 5: Making Forms More Effective
A: Change the Display of Data Conditionally
B: Display a Calendar on a Form
C: Organize Information with Tab Pages

Lesson 6: Making Reports More Effective
A: Cancel Printing of a Blank Report
B: Include a Chart in a Report
C: Arrange Data in Columns
D: Create a Report Snapshot

Lesson 7: Maintaining an Access Database
A: Link Tables to External Data Sources
B: Back Up a Database
C: Compact and Repair a Database
D: Protect a Database with a Password
E: Determine Object Dependency
F: Document a Database
G: Analyze the Performance of a Database