Class description :

MS ACCESS 2000

Prerequisites

Students should have a basic knowledge of mouse and Keyboard usage.

Outline

Introduction to Microsoft Access 

• What is a Database?
• Overview of Access.
• Creating Table

Using Fields in Access:

• Understanding Field Types.
• Field Properties
• Enter data and editing data in Fields.
• Resizing Data Fields.

Formatting Data in Access: 

• Copying Data in Access.
• Formatting Data
• Sorting and Filtering Data

Using Access Wizards and Queries. 

• Using the Form Wizard.
• Using the Report Wizard.
• Using the Query Wizard
• Single Table Queries
• Unmatched Quires
• Setting Criteria in Queries
• Selected Queries

 Organizing Access Data 

• Forms and Reports
• Customizing Reports
• Replacing Data and Form Properties
• Importing Data into Access