Access 2003 Level One

This full-day class is designed to instruct those who will be using Access 2003 databases designed by another person. The class covers the Access 2003 environment and adjusting existing databases.

Prerequisite Classes

· Excel 2003 Level One

Performance-based objectives

The primary objective is to teach the basic skills necessary to use the Access 2003 program.

· examine the Microsoft® Office Access 2003 database application

· manage the data in a database

· examine existing table relationships

· query the database

· design simple forms

· create and modify Access reports

Access 2003 Level One Course Content

Lesson 1: An Overview of Access 2003

· Understand Relational Databases

· Examine the Access Environment

· Open the Database Environment

· Examine an Access Table

Lesson 2: Managing Data

· Examine an Access Form

· Add and Delete Records

· Sort Records

· Display Recordsets

· Update Records

· Run a Report

Lesson 3: Establishing Table Relationships

· Identify Table Relationships

· Identify Primary and Foreign Keys in the Relationships Window

· Work with Subdatasheets

Lesson 4: Querying the Database

· Create a Select Query

· Add Criteria to a Query

· Add a Calculated Field to a Query

· Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

· Examine Form Design Guidelines

· Create a Form Using AutoForm

· Create a Form Using the Form Wizard

· Modify the Design of a Form

Lesson 6: Producing Reports

· Create an AutoReport

· Create a Report by Using the Wizard

· Examine a Report in Design View

· Add a Calculated Field to a Report

· Modify the Format Properties of a Control

· AutoFormat a Report

· Adjust the Width of a Report