Go BackAccess 97: Getting Started

Synopsis
Access 97: Getting Started introduces users to the components of an Access database and shows how to design and create a basic table.

Audience
This course is for the beginning user of Access 97 for Windows.

Time
4 hours

Product Code: ACCC01
After completing Access 97: Getting Started, the user should be able to:

 
Open, view and close database tables and forms
Navigate and find records in tables and forms
Sort records and run a basic query
Design and create a basic table
Add fields to a table
Add records to a table
Introduction to Database Concepts
What is a database?
Explanation of database terminology
Database components

The Access Work Environment
Starting and exiting Access
The Access application windows
Review of basic mousing techniques
Introduction to Help

Opening a Database
Opening an existing database
Orientation to the Database window

Using Tables and Forms
Opening and closing tables
Navigating in tables
Finding records in tables
Opening and closing forms
Navigating and finding records in forms

Using Sorting and Querying
Sorting records
Running a query
Previewing a report

Designing and Creating a Table
Examining a table and its design
Creating a table
Creating text fields
Data types
Setting a primary key

Adding Fields to a Table
Creating text, yes/no and date fields
Creating number and currency fields

Adding Records to a Table
Working in Datasheet view
Adding and saving records
This course is distributed with
 
Exercises, with sample files, that allow users to practice in Access 97
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the Access 97 product
An Access 97 glossary

Go Back