Microsoft Access Training for Microsoft Office 2000

Join the millions of users of Microsoft Access who have obtained the necessary skills to help further their careers. Increase your confidence and productivity by taking our online training courses. You will gain marketable skills to boost your knowledge and productivity in the workplace. Whether you are a student, a retiree, someone returning to the workforce, or an executive, you can now expand your professional skills from the privacy of your own desktop. Training online over the internet - Anytime! Anywhere!

Microsoft Access is a powerful database management program that you can use to efficiently create and manipulate database systems. Microsoft Access allows you to:

• View, enter, and customize data
• Find and display just the information you want to see by sorting and filtering
• Track new information by creating new ideas
• Kepp your information reliable by protecting and validating data, defining relationships, using Lookup fields, and more.
• Answer questions about and analyse your data using queries.
• Merge data from multiple tables to one form using the form wizard
• Steamline data entry.
• Create and enhance a custom report.
• Summarize and group information in reports.
• plus much more . . .

Introduction to Microsoft Access Training

Chapter 1 - Planning and Designing Databases

Why use a Database?
Steps for Planning
Planning a Database
Determining Table Structure
Determining Table Relationships

Chapter 2 - Working with Microsoft Access Training 2000

Overview of Access Window
Selecting an Object
Creating a Database
Creating a Blank Database

Chapter 3 - Working with Records

Navigating Tables and Records
Using a Switchboard
Entering Records using a Data Sheet
Using a Form
Finding a Record
Apply and Remove Filters
Sorting Records
Deleting Records from a Table

Chapter 4 - Working with Tables

Using the Table Wizard
Switching between Object Views
Using Multiple Data Types
Modifying Field Properties
Input Mask Wizard
Lookup Wizard
Setting Primary Keys

Chapter 5 - Working with Forms

Using the Form Wizard
Form Views and Sections
Using Controls
Formatting Properties
Inserting Graphics

ViaLab Exercises

Open a New Database
Sorting a Table
Setting Primary Keys
Create a Form
Editing Controls

Intermediate Microsoft Access 2000 Training

Chapter 1 - Organizing Information and Relationships

Discussing Table Relationships
One-To-Many Relationships
One-To-One Relationships
Enforcing Referential Integrity
Cascade Update and Delete
Printing Database Objects

Chapter 2 - Building and Modifying Tables

Creating Lookup Fields
Data Validation Criteria
Setting Validation Text
Modifying an Input Mask
Optimizing Data Type Usage
Records In a Subdatasheet

Chapter 3 - Building and Modifying Forms

Creating Forms in Design View
Modifying Form Properties
Customizing Form Sections
Modifying Control Properties
Using the Sub Form Control
Using a Calculated Control

Chapter 4 - Introduction to Queries

Multi-table Select Query
Modifying Query Properties
Specifying Criteria in Fields
Setting Join Properties
Specifying Join Properties
Applying a Filter by Form
Optimizing Queries Using Indexes

Chapter 5 - Types of Queries

Creating a Parameter Query
Types of Action Queries
Action Query (Append)
Action Query (Delete)
Totals Query

ViaLab

Opening Table Relationship Window
Creating a relationship between two tables
Opening a table in design view
Using the Query function
Creating a Query

Advanced Training

Chapter 1 - Produce Reports

You Will Learn
Report Wizard
Create a Report in Design View
Produce Reports from Queries
Move and Resize a Control
Modify Format Properties
Preview and Print Reports

Chapter 2 - Working with Reports

You Will Learn
Use Report Sections
Set Section Properties
Use the Control Toolbox
Modify Control Properties
Insert a Graphic on a Report
Use Calculated Controls

Chapter 3 - Produce Reports

You Will Learn
Import Data to a New Table
Export Database Records
Drag and Drop to Excel
Present Information as a Chart
Link Existing Data
Convert a Database to a Previous Version

Chapter 4 - Using Access Tools and Web Capabilities

You Will Learn
Backup and Restore a Database
Compact and Repair a Database
Create a Switchboard
Create a Data Access Page
Use Group and Sort Features
Save as a Web Page
Create Hyperlinks

Chapter 5 - Advanced Access Features

You Will Learn
Encrypt and Decrypt a Database
Set and Modify Databases Passwords
Set Startup Options
Use Add Ins
Use Simple Replications
The Macro Builder
Run Macros Using Controls