Access 2002

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

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

Time
3 hours

Product Code: AXPM03

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.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.