Access 2002 : Level 3

Course Description

Overview: You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.

Prerequisites: Access 2002: Level 1, Access 2002: Level 2 or equivalent knowledge:

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• put existing data into correctly designed tables and compact your database.
• use a variety of techniques to summarize data.
• create and revise basic Access macros.
• create macros that require data entry in certain fields and automate data entry in others.
• use advanced features to enhance forms.
• use advanced features to enhance reports and distribute a report to non-Access users.
• use Office Links to use Access data in other Office programs.

Course Content

Lesson 1: Structuring Existing Data

Use the Table Analyzer Wizard for Help

Decide on Your Own Design

Create a Junction Table

Modifying the Original Tables and Completing the Design

Compact and Repair a Database

Lesson 2: Summarizing Data

Group and Summarize Records in Different Ways

Summarize with a Crosstab Query

Pivot Query Results

Displaying a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Create a Macro

Attach a Macro to a Command Button

Restrict Records

Lesson 4: Adding Interaction and Automation with Macros

Require Data Entry with a Macro

Displaying a Message Box with a Macro

Automate Data Entry

Lesson 5: Making Forms More Usable

Change the Display of Data Under Certain Conditions

Display a Calendar on a Form

Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

Cancel Printing of a Blank Report

Including a Chart

Arranging Data in Columns

Distributing Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

Merge Access Data with a Word Document

Publishing Access Data as a Word Document

Analyze Access Data in Excel

Appendix A: Access Object Names