Access 2003 Level 1

Hours: 8

Short Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.

Course Outline

Lesson 1: An Overview of Access 2003

Relational Databases
The Access Environment
The Database Environment
Examine an Access Table

Lesson 2: Managing Data

Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report

Lesson 3: Establishing Table Relationships

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets

Lesson 4: Querying the Database

The 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

Form Design Guidelines
Create AutoForms
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
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report

KnowledgeAir