Access 2002 Advanced

1 day

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 Introduction and Access 2002 Intermediate, or equivalent knowledge.

Benefits

Students will learn advanced Access 2002 skills, including how to structure existing data, summarize data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.

Target student

Anyone who uses Access 2002 as a tool for getting their work done. Job responsibilities might include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced capabilities, and using Access tools, as well as supporting less-advanced Access users.

What's next

Access 2002 VBA Programming, the next course in this series, teaches students how to develop custom applications using Access.

Structuring Existing Data

Use the Table Analyzer Wizard for Help
Decide on Your Own Design
Create a Junction Table
Modify the Original Tables and Completing the Design
Compact and Repair a Database

Summarizing Data

Group and Summarize Records in Different Ways
Summarize with a Crosstab Query
Pivot Query Results
Display a Graphical Summary on a Form

Simplifying Tasks with Macros

Create a Macro
Attach a Macro to a Command Button
Restrict Records

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 Usable

Change the Display of Data Under Certain Conditions
Display a Calendar on a Form
Organize Information with Tab Pages

Making Reports More Powerful

Cancel Printing of a Blank Report
Include a Chart
Arrange Data in Columns
Distribute Reports as a Snapshot

Expanding the Reach of Your Data

Merge Access Data with a Word Document
Publish Access Data as a Word Document
Analyze Access Data in Excel