203-220-2218
skip to the main content area of this page
Training: Course Outline

2008 Training Schedules

To register call:
1-203-220-2218

Access 2003, Advanced

Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Audience

This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft® Office Access 2003 database program. The Advanced course is for the individual 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.

Prerequisites

To ensure the successful completion of Microsoft® Office Access 2003, Advanced, we recommend completion of the following courses, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source:

  • Microsoft® Office Access 2003, Introduction
  • Microsoft® Office Access 2003, Intermediate

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

Student Responsibilities
In order for a class to be successful, all students should share the same general level of knowledge and experience. If a participant does not demonstrate these, the instructor will take the necessary steps either to prepare the participant or place him/her in a more appropriate course. This policy is intended to maintain the high level of quality control that you have come to expect.
<< Back to Schedule