After completing Access 2000 MOUS: 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 into a table |
 | 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 2000 |
 | 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 2000 |
 | 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 2000 MOUS: Creating Databases (A2KM01) |
 | Access 2000 MOUS: Building Tables (A2KM02) |
|
Microsoft® is a registered trademark of Microsoft Corporation.
Access® is a registered trademark of Microsoft Corporation.
Microsoft and the Microsoft Office User Specialist logo are registered trademarks of Microsoft Corporation in the United States and other countries.
|