After completing Access 2002: Modifying Tables, the user should be able to:
 | Insert and delete records and fields |
 | Modify the appearance and structure of the table in Design View |
 | Change the size, format, and default value of fields |
 | Use the Lookup and Input Mask wizards |
|
Modifying Data
 | Deleting records from a table |
 | Inserting new records |
 | Deleting a field |
 | Using the Office Clipboard |
Modifying Tables
 | Using Design view to modify tables |
 | Changing the font for a table |
Modifying Field Properties
 | Specifying field sizes |
 | Specifying formats |
 | Specifying captions |
 | Specifying default values |
 | Specifying required fields |
Modifying Tables Using the Wizards
 | Using the Lookup Wizard |
 | Using the Input Mask Wizard |
|
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: Building Tables (AXPM02) |
|
 | 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.
|