Intermediate Microsoft Access 2003 (1 day)

Intermediate Microsoft Access 2003 Training Overview

This Microsoft Access training course is designed for students whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft Office Access 2003.

Intermediate Microsoft Access 2003 Training Course Goals

• Learn to restructure an existing set of data to improve the design of a database.
• Learn to use a variety of techniques to summarize and present data with queries.
• Learn to create and revise basic Access macros.
• Learn to create macros that improve data entry efficiency and integrity.
• Learn to improve the effectiveness of data entry in forms.
• Learn to improve the effectiveness of data displayed in reports.
• Learn to maintain an Access database by using various utility tools.

Intermediate Microsoft Access 2003 Training Course Prerequisites

Experience in the following areas is required:

• Basic Microsoft Access Skills as taught in Webucator's Introduction to Microsoft Access Training course.

Intermediate Microsoft Access 2003 Training Course Outline

1. Structuring Existing Data in Microsoft Access
   1. Import Data
   2. Analyze Tables
   3. Create a Junction Table
   4. Improve Table Structure
2. Writing Advanced Queries in Microsoft Access
   1. Create Unmatched and Duplicates Queries
   2. Group and Summarize Records Using the Criteria Field
   3. Summarize Data with a Crosstab Query
   4. Create a PivotTable and a PivotChart
   5. Display a Graphical Summary on a Form
3. Simplifying Tasks with Macros in Microsoft Access
   1. Create a Macro
   2. Attach a Macro to a Command Button
   3. Restrict Records Using a Where Condition
4. Adding Interaction and Automation with Macros in Microsoft Access
   1. Require Data Entry with a Macro
   2. Display a Message Box with a Macro
   3. Automate Data Entry
5. Making Forms More Effective in Microsoft Access
   1. Change the Display of Data Conditionally
   2. Display a Calendar on a Form
   3. Organize Information with Tab Pages
6. Making Reports More Effective in Microsoft Access
   1. Cancel Printing of a Blank Report
   2. Include a Chart in a Report
   3. Arrange Data in Columns
   4. Create a Report Snapshot
   5. Maintaining an Access Database
   6. Link Tables to External Data Sources
   7. Back Up a Database
   8. Compact and Repair a Database
   9. Protect a Database with a Password
   10. Determine Object Dependency
   11. Document a Database
   12. Analyze the Performance of a Database

Intermediate Microsoft Access 2003 Training Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Intermediate Microsoft Access 2003 Training Technical Requirements

1. Microsoft Access 2003

Class Files for Intermediate Microsoft Access 2003 Training

The class files for this course are included on a CD that is shipped with the manual.