MONROE BUSINESS ASSOCIATES

INTRODUCTION TO ACCESS

(6 hours)

Who should attend:

Individuals attending this course should be familiar with the Windows 95 operating system and are using Access for the first time.

Prerequisites:

A working knowledge of the skills outlined within Introduction for Windows is required. No previous Access experience is required.

Course Outline:

Database Terminology

· Terminology

· Access Objects

· Opening a Database

· Viewing and Navigating Table Data

· Using Help

Constructing a New Database

· Creating a New Database

· Creating Tables

· Defining Data Types

· Setting a Primary Key

· Editing Records

· Using the Table Wizard

· Sorting

· Filter By Selection

· Finding and Replacing

Building a Simple Form

· Using the Form Wizard

Queries

· Understanding Queries

· Creating Simple Queries

· Selecting Fields

· Specifying a Sort Order

· Modifying

· Specifying Criteria

· Queries Based on Relationships

· Calculating in a Query

Creating Basic Reports

· Using the Report Wizard

· Using Print Preview