Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
Access 2002: Building Tables shows users how to create and populate database tables in Access 2002.

Audience
This course is for anyone who wants to get the most out of using Access 2002.

Time
2 hours

Product Code: AXPM02
After completing Access 2002: Building Tables, the user should be able to:

Explain the structure of a table, the data types used in the table, and the function of primary keys
Create a table using the wizard
Enter records into the table through a form or datasheet

Understanding Table Structure
Creating a table structure
Using the Design view
Using multiple data types
Setting primary keys
Saving the table

Creating Tables
Beginning the Table Wizard
Setting a primary key
Selecting data type options
Completing the Table Wizard

Entering Records
Entering records using a datasheet
Using data entry tricks
Navigating records in a table, query, or form
Entering records using a form

This course has the following features:

Exercises that allow users to practice in Access 2002
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to Access 2002
A glossary
A Skill Assessment

Office 2000: Getting Started (O2KC01)
Office 2000: Editing Text and Printing (O2KC02)
Office 2000: Text and Document Formats (O2KC03)
Office 2000: Introduction to Access (O2KC08)
Access 2002: Creating Databases (AXPM01)

Access 2002: Modifying Tables (AXPM03)
Access 2002: Sorting and Filtering (AXPM04)
Access 2002: Relationships & Queries (AXPM05)
Access 2002: Building Forms (AXPM06)
Access 2002: Producing Reports (AXPM07)
Access 2002: Advanced Tasks (AXPM08)

Microsoft® is a registered trademark of Microsoft Corporation.

Access® is a registered trademark of Microsoft Corporation.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.