Structuring Existing Data

·         Analyze Tables

·         Create a Junction Table

·         Improve Table Structure

 

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

 

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

 

Making Effective Use of Forms

·       Display a Calendar on a Form

·       Organize Information with Tab Pages

·       Display a Summary of Data in a Form

 

Making Reports More Effective

·         Include a Chart in a Report

·         Print Data in Columns

·         Cancel Printing of a Blank Report

·         Create a Report Snapshot

 

Maintaining an Access Database

·         Link Tables to External Data Sources

·         Manage a Database

·         Determine Object Dependency

·         Document in a Database

·         Analyze the Performance of a Database