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

 

Synopsis
Access 2000 MOUS: Modifying Tables shows users how to edit table data table structure and field properties in Access 2000.

Audience
This course is for anyone preparing for the MOUS Access 2000 Core certification exam.

Time
3 hours

Product Code: A2KM03
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.

 
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.