Access 2003 - Level 2

You Will Learn To

Create more advanced queries, forms, and reports; use macros; access external data.

Who Should Attend

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

Course Content

Structuring Existing Data

• Import Data

• Analyze Tables

• Create a Junction Table

• Improve Table Structure

Writing Advanced Queries

• Create Unmatched and Duplicates Queries

• Group and Summarize Records Using the Criteria Field

• Summarize Data with a Crosstab Query

• Create a PivotTable and a PivotChart

• Display a Graphical Summary on a Form

Simplifying Tasks with Macros

• Create a Macro

• Attach a Macro to a Command Button

• Restrict Records Using a Where Condition

Adding Interaction and Automation with Macros

• Require Data Entry with a Macro

• Display a Message Box with a Macro

• Automate Data Entry

Making Forms more Effective

• Change the Display of Data Conditionally

• Display a Calendar on a Form

• Organize Information with Tab Pages

Making Reports More Effective

• Cancel Printing of a Blank Report

• Include a Chart in a Report

• Arrange Data in Columns

• Create a Report Snapshot

Maintaining an Access Database

• Link Tables to External Data Sources

• Back Up a Database

• Compact and Repair a Database

• Protect a Database with a Password

• Determine Object Dependency

• Document a Database

• Analyze the Performance of a Database