Access 2002 - Level 1 Training Class

Lesson 1: Working with a Relational Database

Identify Uses of a Relational Database
Define Database Terminology
Create a New Database Based on a Template
Examine the New Database

Lesson 2: Planning a Database

Identify Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize the Data
Designate Primary and Foreign Keys
Identify Table Relationships

Lesson 3: Building the Basic Structure

Create a Blank Database
Create a Table using a Wizard
Compare Datasheet and Design Views
Create Tables in Design View
Create Relationships between Tables

Lesson 4: Working with Tables

Modify a Table Design
Work in Datasheet View
Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

Examine a Query
Create a Query using a Wizard
Work in Query Design View
Select Records
Edit Values in a Query Datasheet
Add a Calculated Field to a Query
Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

Create AutoForms
Create a Form Using a Wizard
Modify the Design of the Form
Use Forms to Work with Data

Lesson 7: Creating and Using Reports

Create an AutoReport
Create a Report Using a Wizard
Examine a Report in Design View
Create a Calculated Field
Change the Format of a Control
Change the Style of a Report
Adjust Report Width

Lesson 8: Managing a Database and Data

Import Data
Maintain Record Integrity
Exporting Data
Documenting Table Relationships

Lesson 9: Controlling Data Entry

Make Data Entry More Accurate
Make Data Entry More Efficient
Facilitate Data Entry

Lesson 10: Finding and Joining Data

Find Data with Filters
Get the Correct Data with Query Joins
Building Bridges Between the Data
Relating Data Within a Table

Lesson 11: Creating Flexible Queries

Summarizing Data with Queries
Enter Criteria on the Fly
Maintain Data with Queries

Lesson 12: Improving Your Forms

Enhance the Appearance of a Form
Enhance the Usability of a Form
Make Your Forms More Professional
Display Form Data from Multiple Tables

Lesson 13: Customizing Your Reports

Organize Report Information
Enhance Data Layout
Working with Report Pagination
Summarizing Information
Add a Subreport to an Existing Report
Creating Mailing Labels

Lesson 14: Making Your Data Available on the Web

Create a Data Access Page
Improving the Look of a Data Access Page
Editing Data Using a Data Access Page
Group Records in a Data Access Page