Access 2003 Level Three

This full-day class is designed to cover the most advanced topics in Microsoft Access 2003.

Prerequisite Classes

· Microsoft Access 2003 Level One

· Microsoft Access 2003 Level Two

Access 2003: Level Three

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

· restructure an existing set of data to improve the design of a database

· use a variety of techniques to summarize and present data with queries

· create and revise basic Access macros

· create macros that improve data entry efficiency and integrity

· improve the effectiveness of data entry in forms

· improve the effectiveness of data displayed in reports

· maintain an Access database by using various utility tools

Access 2003 Level Three Course Content

Lesson 1: Structuring Existing Data

· Import Data

· Analyze Tables

· Create a Junction Table

· Improve Table Structure

Lesson 2: 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

Lesson 3: Simplifying Tasks with Macros

· Create a Macro

· Attach a Macro to a Command Button

· Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

· Require Data Entry with a Macro

· Display a Message Box with a Macro

· Automate Data Entry

Lesson 5: Making Forms More Effective

· Change the Display of Data Conditionally

· Display a Calendar on a Form

· Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

· Cancel Printing of a Blank Report

· Include a Chart in a Report

· Arrange Data in Columns

· Create a Report Snapshot

Lesson 7: 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