ActiveEducation's Access 97 Introduction

Access 97 Introduction (MOUS Version) Access is a powerful database management system for microcomputers. ActiveEducation' s course, Access 97: Introduction (MOUS Version), presents methods for performing basic database management tasks. Although no prior knowledge of databases is required, students should be familiar with basic computer operations. The combined courses Access 97: Introduction (MOUS Version), Access 97: Intermediate (MOUS Version), and Access 97 Advanced (MOUS Version) include discussions and exercises for all topics included in the Microsoft Office User Specialist, Expert-level test. Course Objectives

Work with Access

Find, replace, and sort table data

Set up a table

Query a database

Design a form

Design a report

Use additional MOUS test topics (See Lesson 7)

Lesson Topics Lesson 1:

Working with Access

Understanding Databases

Viewing Information in a Table

Accessing Online Help

Lesson 2:

Setting Up a Table

Creating a Database File

Modifying the Table Design

Setting Field Properties

Entering and Editing Records in a Table

Printing a Dynaset

Setting Relationships and Printing

Lesson 3:

Designing a Form

Creating a Form

Resizing and Moving a Control

Adding a Label to a Form

Setting Control Properties

Using the Form View

Lesson 4:

Finding, Replacing, and Sorting

Table Data

Finding a Specific Field Value

Finding and Replacing Data

Using Filters

Sorting Records

Lesson 5:

Querying a Database

Creating a Query

Modifying Fields in a Dynaset

Creating a Calculated Field

Creating a Multiple-Table Query Lesson 6:

Designing a Report

Creating a Report

Customizing a Report

Generating Mailing Labels Lesson 7:

Additional MOUS Test Topics

Modifying the Database Window

Creating Lookup Fields and OLE

Object Fields