We Make it Easy to Learn Microsoft Word, Excel, Outlook and More - No Matter What Your Skill Level ...
Microsoft Access XP Advance Training Video


Course Outline

Course Description
Join Microsoft Access™ expert Sheila Vander Maas featuring state-of-the-art training covering beginning, intermediate, and advanced levels in this basic training series.

About Trainer
Sheila is one of our most popular trainers.  With 10 years of experience in the training and education area she brings an easy to understand style, along with confident delivery, that is highly sought after by our clients.  Sheila received her degree from a respected Michigan university and has been recognized throughout her career for volunteering her time and knowledge to various non-profit organizations.  Sit back and enjoy learning from one of Computrain Solutions original software educators.  Microsoft Access XP Advance Training Video can be purchased individually or as a whole with Microsoft Office Suite.  

Course Sets - Single User License *

(*) Please Email sales@computrainsolutions.com if you have question regarding to our multi-user licensing for this course or check our FAQ on the left menu.

Detailed Course Outlines for Access XP Advance Training Video can be found below:
Access XP Beginning
1.0

Introduction

1.1

Getting Started

1.2

Opening an Existing Database

1.3

The Access Desktop

1.4

The Database Window

1.5

A Preview of the Database Components

2.0

Working with Existing Tables

2.1

Viewing & Navigating Table Data

2.2

Adding Records to a Table

2.3

Selecting and Deleting Records

2.4

Editing Table Data

3.0

Find and Replace Commands

3.1

Finding a Replacing Table Data

4.0

Customizing the Datasheet & Using Spell Check Functions

4.1

Modifying the Appearance of a Datasheet

4.2

Spell Check & Auto Correct

5.0

Form Basics

5.1

Moving from Record to Record

5.2

Adding & Editing a Record

5.3

Filtering

5.4

Sorting

6.0

Creating Forms

6.1

Auto Forms

6.2

Using a Form Wizard

6.3

Conditional Formatting

7.0

Report Basics

7.1

Moving from Page to Page

7.2

Zooming In & Out

7.3

Viewing Multiple Pages

8.0

Creating Reports

8.1

Creating Simple Reports

8.2

Using Auto Reports

8.3

Using the Report Wizard

9.0

Printing Database Objects

9.1

Print Preview

9.2

Printing Table Data Sheets

9.3

Printing Queries

9.4

Printing Forms

9.5

Printing Reports

10.0

Getting Help

10.1

Using the Help Toolbar

10.2

Using Help Content, Answer Wizard & the Index

11.0

Database Maintenance

11.1

Backing Up & Restoring Databases

11.2

Compacting & Repairing a Database

11.3

Converting a Database to a Previous Version

12.0

Database Organization

12.1

Organizing Database Objects into Groups

Access XP Intermediate
1.0

Planning & Designing a Database

1.1

Inputs & Outputs

1.2

Normalization

2.0

Creating a Database Using the Wizard

3.0

Creating a Database from Scratch

4.0

Building & Modifying Tables

4.1

Creating Tables Using the Wizard

4.2

Creating Tables from Scratch

5.0

Understanding Primary Keys & Using Lookup Wizard

5.1

Setting Primary Keys

5.2

The Lookup Wizard

6.0

Understanding Field Properties

6.1

Field Properties

6.2

Input Masks

7.0

Understanding the Indexed Field Properties

7.1

An Explanation of Indexing

7.2

Changing the Indexed Field Property

8.0

Understanding Access Relationships

8.1

Introduction to Relationships

8.2

Benefits of Relationships

8.3

Types of Relationships

9.0

Working with Access Relationships

9.1

Creating Relationships

9.2

Referential Integrity

9.3

Printing Relationships

9.4

Deleting Relationships

10.0

Creating & Working with Queries

10.1

Designing Simple Queries

10.2

Creating a Query from Scratch

10.3

Creating a Query Using the Wizard

11.0

Creating & Working with Criteria

11.1

Refining Queries with Criteria

11.2

Updatability of Query Results

11.3

Queries Based on Multiple Tables

Access XP Advanced
1.0

Modifying Forms

1.1

Forms in Design View

1.2

Using Toolbox & Fieldlist

1.3

Adding Controls

1.4

Selecting Controls

1.5

Moving, Sizing & Deleting Controls

1.6

Aligning Controls

1.7

Changing Control Properties

1.8

Changing the Tab Order Controls

1.9

Form Properties

1.10

Working with Combo Boxes & List Boxes

2.0

Modifying Reports

2.1

Report in Design View

2.2

Working with Controls

2.3

Working with Report Properties

2.4

Modifying Selection Criteria

3.0

Database Startup Options

3.1

Setting the Application, Icon & Startup Form

3.2

Designing Other Startup Information

4.0

Exporting to Different File Types

4.1

Exporting to another Database

4.2

Exporting to a Spreadsheet

4.3

Exporting to ASCII

4.4

Exporting to HTML

5.0

Importing from Different File Types

5.1

Importing from another Database

5.2

Importing Spreadsheet Data

5.3

Importing ASCII Data

5.4

Importing from HTML

6.0

Linking Tables

6.1

Linking to another Access Database

6.2

Linking to another Type of Database

6.3

Deleting a Link

6.4

The Linked Table Manager

Computrain Solutions is a member of the Better Business Bureau
Copyright ©2004. Computrain Solutions. All Rights Reserved.