Microsoft Access 2003 Training CD ROMs

Access 2003 Trainer: Casey McNeal Casey has been speaking professionally for over nine years. His diverse professional background and his life as a stand-up comic have prepared him for the life that he now lives and loves. His students love his light-hearted format and come away from this course excited and well-prepared to apply their new skills immediately.

Unlimited User License

Access 2003 Training - Level 1

Introduction

Database Concepts

Relational Databases

Task Pane

Tables

Forms

Queries

Reports

Database Wizard

Database Development

Building a Database

Table Essentials

Table Wizard

Relationships with Wizards

Setting up Field Names

Setting Data Types

Setting a Primary Key

Datasheet View

Add New Record

Delete Record

Office Clipboard

Table Appearance

Column Width

Changing Font & Cell Effects

Managing Columns Appearance

Filter Techniques

Sorting Records

Finding a Record

Filtering By Selection

Query Essentials

Relationships

Query Wizard

Adding Criteria

Using Comparison Operators

Using Wildcards

Access 2003 Training - Level 2

Form Essentials

Using the Form Wizard

Creating Forms with AutoForm

Report Essentials

Using the Report Wizard

Adding a Calculated Control

Using Print Preview

Using the Label Wizard

Field Properties

Field Size

Date and Time

Context Sensitive Help

Yes & No Fields

Default Value

Validation Rule

Indexed Field

Create a Lookup

Inserting a Lookup Field

Lookup Wizard

Limit to List

Importing & Exporting Data

Export to Excel

Importing from Access Databases

Importing Data from Excel

Linking Data from Excel

Creating a Shared Database

Using the Database Splitter

Relationships

Creating Table Relationships

Enforcing Referential Integrity

Understanding Cascade Options

Printing Database Information

Access 2003 Training - Level 3

Advanced Query Techniques

Using Parameter Queries

Establishing Multiple Parameters

Setting up Calculated Fields

Creating Summary Queries

Using Access & HTML

Access and HTML

Using Hyperlinks

Publish Database to HTML Format

Data Access Pages

Using Data Access Pages

Merging Access into Word

The Access Mail Merge Wizard

Creating the Form Letter

Running the Merge

Action Queries

Make Table Query

Running an Append Query

Running a Delete Query

Running an Update Query

Printing Queries

Database Maintenance

Compact & Backup

Using Compact & Repair Utility

Using Backup & Restore Tool

Advanced Form Design

Printing Records

Creating and Using Form Controls

Calculated Controls

Object Properties

Working with Controls

Advanced Form Design

Adding Fields

Saving & View Form

Adjust Tab Order

Add Combo Box

Add Command Button

Add Command Button

Adding Graphics to Forms

Using Headers & Footers

ActiveX Control

Using Input Masks in Forms

Advanced Report Design

Understanding the Report Design

Headers & Footers

Move & Resize Controls

Adding Controls

Adding Calculated Controls

Using Group & Sorting Controls

Working with the Pagebreak Control

Working with the Report Footer