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.
|