Access 2007 - Level 2

You Will Learn To

Structure data effectively; create more advanced queries, forms, and reports; use macros.

Who Should Attend

Access users who have mastered the skills taught in Access 2007 - Level 1.

Course Content

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 a Database

• Analyze the Performance of a Database