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.

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information