Microsoft Access 2003 Level 3 Course

Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

To ensure the successful completion of Microsoft® Office Access 2003: Level 3, we recommend completion of the following courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source:

• Microsoft® Office Access 2003: Level 1
• Microsoft® Office Access 2003: Level 2

This course is rated as an Advanced Course, suitable for accomplished computer users.

Topics covered on the 1 day Microsoft Access 2003 Level 3 course

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