print
Course Name
Microsoft Access 2003 (Levels 1-2-3)

Contact Hours: 24

Course Description

Our Access 2003 gives you powerful new tools for managing your data. Share your database with co-workers over an Intranet, find and retrieve information quickly, and take advantage of automated, pre-packaged solutions to quickly create databases. Our interactive training series will show you how to utilize all of the tools contained within the most versatile and popular database program available! We suggest a 90 day period for completion of study. You will have 1 year access to this course.

Outcome

  • You will be able to apply this knowledge in the workplace
  • You will have an appreciable understanding of the subject matter
  • You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time

Assessment

Testing as part of the course through exam simulation engines


Outline

Level 1 - Overview
Introduction
The Course Scenario
Creating a Database
Creating a Table in Design View
Entering Data into a Table
Using AutoForm
Using AutoReport
Using AutoPage
Summary

Level 2 - Overview
Using the Simple Query Wizard
Creating a Query in Design View
Joining Tables
Using Computed Fields
Using the Crosstab Query Wizard
Creating a Form
Using the Form Wizard
Changing Form Properties
Handling Form Events
Creating a Report
Using the Report Wizard
Creating a Report in Design View
Creating Data Access Pages
Using the Data Access Page Wizard
Summary

Level 3 - Overview
Finding and Updating Records
Creating Update and Delete Queries
Changing Table Structure
Modifying a Datasheet
Using the PivotTable View
Establishing Validation Rules
Setting Default Values
Enforcing Referential Integrity
Defining Relationships
Sorting and Indexing Data
Using Database Utilities
Importing and Exporting Data
Summary