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 |
|