Microsoft Access 2000

1. Getting Started

• A few terms

• Getting started

• Blank Access database

• Access database wizards, pages, and projects

• Open an existing database

• Converting to Access 2000

 2. Screen Layouts

• Database window

• Design view

• Datasheet view

 3. Creating Tables

• Introduction to tables

• Create a table in design view

• Field properties

• Primary key

• Indexes

• Field validation rules

 4. Datasheet Records

• Adding records

• Editing records

• Deleting records

• Adding and deleting columns

• Resizing rows and columns

• Freezing columns

• Hiding columns

• Finding data in a table

• Replace

• Check spelling and AutoCorrect

• Print a datasheet

 5. Table Relationships

• Declaring table relationships

 6. Sorting and Filtering

• Sorting

• Filter by Selection

• Filter by Form

• Saving a filter

• Remove a filter

7. Queries

• Introduction to queries

• Create a query in design view

• Query wizard

• Find duplicates query

• Delete a query

  8. Forms

• Create a form using the wizard

• Create a form in Design View

• Adding records using a form

• Editing forms

 9. Form Controls

• List and Combo Boxes

• Check Boxes and Option Buttons

• Command Buttons

 10. Subforms

• What Is A Subform?

• Create a Form and Subform at Once

• Subform Wizard

• Drag-and-Drop Method

 11. More Forms