After completing Access 97: Using a Database the user should be able to:

 

	Change a table's design
	Edit and add records in a table or form
	Create and modify basic queries
	Create and modify simple forms
	Create a basic report

Modifying a Table's Design
Changing field names
Inserting and deleting fields
Moving fields
Changing column widths

Finding Records
    Searching through a specific field
    Searching through all fields in a table

Editing Records
Selecting values and records
Deleting records
Using Undo commands
Copying values and records

Query Basics
Running a query
Viewing a query's design
Creating and designing a query
Controlling the number of visible fields

Sorting and Saving a Query
Controlling the order of records
Rearranging the design grid fields
Saving and naming a query

Setting Criteria in a Query
Setting selection criteria
Controlling which records appear
Editing records from the query datasheet

Form Basics
Viewing data in a form
Creating a form with Form Wizard
Specifying fields and form layout
Basic form design

Modifying Simple Forms
Modifying a form's design
Previewing a form
Printing a form

Sorting and Editing Records in a Form
Sorting records
Filtering records
Editing records
Adding new records

Creating Basic Reports
Previewing and printing a report
Reviewing basic report design
Creating a report with Report Wizard

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