Access 2003: Level 1

 Course Description

Overview: Students will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools

Prerequisites: Windows 2000 or Windows XP.

 

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

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

 

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