Specialized Solutions - Access 2003 Certification

Home : Technical Training Titles : Microsoft Training Titles : Microsoft End-User Titles : Access 2003

Microsoft Access 2003 Certification

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!

Audience:

Anyone wanting to become more proficient in Access XP

Deployment Options:

- Video Training
- CD-ROM
- E-learning
-ThinkTank Server Solution

Learning / Exam module:

Course Duration:
Each learning module is approximately 18-24 hours.

Learning Segments:

Introduction

Level 1 - Overview

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