Microsoft Access 2002 Level 3
Structuring Existing Data
Use the Table Analyzer Wizard for Help
Decide on Your Own Design
Create a Junction Table
Modify the Original Tables and Complete 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
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
Class Information
Duration: 1 day
Prerequisite: Microsoft Access 2002 Level 2 or equivalent experience.
Course Materials: Course manual (084402S3)
Description: Students 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.