MS Access 2003 (MOS) CD Training (CBT) Course

Course Contents:

Introduction
Level 1 - Overview
The Course Scenario
Creating a Database
Create an Access Database
Creating a Table in Design View
Create a Table and Define Fields
Entering Data into a Table
Use the Simple Query Wizard
Using AutoForm
Create a Form Using AutoForm
Using AutoReport
Create a Report Using AutoReport
Using AutoPage
Create a Data Access Page Using AutoPage
Summary
Level 1 - Review

Level 2 - Overview
Using the Simple Query Wizard
Creating a Query in Design View
Create a Query in Design View
Joining Tables
Join Tables in a Query
Using Computed Fields
Create a Calculated Field in a Query
Using the Crosstab Query Wizard
Create a Crosstab Query
Creating a Form
Using the Form Wizard
Add a Label to a Form Header
Changing Form Properties
Edit a Text Box Control on a Form
Handling Form Events
Use a Combo Box Control in a Form
Creating a Report
Using the Report Wizard
Create a Report with a Wizard
Creating a Report in Design View
Create and Modify an Aggregate Function
Creating Data Access Pages
Using the Data Access Page Wizard
Create and View a Data Access Page
Summary
Level 2 - Review

Level 3 - Overview
Finding and Updating Records
Find a Record
Creating Update and Delete Queries
Create an Update Query
Changing Table Structure
Modifying a Datasheet
Format a Datasheet
Using the PivotTable View
Create a PivotTable
Establishing Validation Rules
Setting Default Values
Enforcing Referential Integrity
Create One-to-Many Relationships
Defining Relationships
Sorting and Indexing Data
Sort Records
Using Database Utilities
Compact and Repair a Database
Importing and Exporting Data
Export Data to Excel 2003
Summary
Level 3 - Review