Access 2003 Level 3

Performance-Based Objectives

· 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.

·

BONUS

TIPS & TRICKS HANDOUT

Maintain An Access Database By Using Various Utility Tools.

· Import Data

· Analyze Tables

· Create a Junction Table

· Improve Table Structure

· 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

Appendix A: Microsoft Office Specialist Program