We Make it Easy to Learn Microsoft Word, Excel, Outlook and More - No Matter What Your Skill Level ...
Microsoft Access XP Beginner 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 Beginner 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 Beginner 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.