Introduction to Microsoft Access

Duration: 1 day (6 hours)

Prerequisite(s): Familiarity with the Windows environment and at least one other Microsoft Office application

Environment: Microsoft Windows

Version(s): All through Access 2003. Taught using Access 2003.

Support: Upon completion of this seminar, the student will be entitled to unlimited, free telephone support in Access

Who Should Take This Seminar: Introduction to Microsoft Access is designed to introduce the student to Microsoft Access, the popular database product. Upon completion of this seminar the student will be able to design and use database tables, forms, queries, and reports. The student should be familiar with Windows basics and at least one other Microsoft Office application before taking this seminar. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Database Basics
2. Working With an Existing Access Database
1. Defining the objects that make up an Access database
2. Working with tables
1. Adding records
2. Editing records
3. Deleting records
3. Finding records
4. Creating filters to select records
5. Creating a simple data entry form
6. Using forms to enter data
7. Printing Access objects
3. Creating a New Access Database
1. Creating tables
1. Using the Table Wizard
2. Using the Design View
3. Defining fields field properties
2. Creating a form using the Form Wizard
1. Establishing form layout
2. Creating controls
3. Defining control properties
3. Creating select queries
1. Using the Query Wizard
2. Using the Design View
3. Viewing the query dynaset
4. Defining criteria
5. Linking multiple tables in a query
6. Creating calculated fields
4. Creating reports using the Report Wizard
1. Establishing report layout
2. Grouping data
3. Changing the report design
4. Printing a report
5. Creating mailing labels
6. Creating calculated controls