Course 4127: Core Training for Microsoft Access 2002

Introduction This course introduces the basic features and tools of Microsoft® Access 2002, including the following: viewing tables, exploring queries, forms, and reports, using the help feature, creating a new database, importing and exporting information, simplifying data entry with forms, locating specific information, keeping your information accurate, and working with reports and pages.

This course has been certified as Microsoft Office Specialist Approved Courseware, and covers all exam skill standards.

Modules & Lessons Core Training for Microsoft Access 2002 Pre-Assessment Pre-Assessment Getting to Know Access Lesson Introduction Understanding Access Viewing Tables Exploring Queries Exploring Forms Viewing Reports Getting Help Creating a New Database Lesson Introduction Creating a New Database Structure Checking the Work of a Wizard Creating Tables Refining How Data Is Displayed Formatting Tables Importing and Exporting Information Lesson Introduction Importing Data from Excel Importing Data from Text Files Importing Data from an Access Database Importing Data from Other Databases Importing Data from an HTML File Exporting Data to Other Applications Sharing Access Data in Other Ways Simplifying Data Entry with Forms Lesson Introduction Creating a Form Using a Wizard Refining Form Properties Adding Controls to a Form Creating a Form Using an AutoForm Adding a Subform to a Form Creating a Form and Subform with a Wizard Locating Specific Information Lesson Introduction Sorting Information in a Table Filtering Information in a Table Filtering Information By Form Locating Information Using Multiple Criteria Creating a Query with a Wizard Creating a Query in Design View Performing Calculations in a Query Keeping Your Information Accurate Lesson Introduction Restricting Data with the Data Type Setting Restricting Data with an Input Mask Restricting Data with Validation Rules Restricting Data with a Lookup List Deleting Records from a Table Working with Reports Lesson Introduction Creating a Report Using a Wizard Creating a Report from Scratch Adding a Subreport to a Report Previewing and Printing a Report Working with Pages Lesson Introduction Creating Static Web Pages Creating a Data Access Page with AutoPage Creating a Data Access Page with the Page Wizard Saving an Object as a Data Access Page Post Assessment Post Assessment Reference and Glossary Quick Reference Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled