Access 2002: Intermediate

« back to previous page

Description:	This course will introduce students to the skills needed for creating, revising, and customizing the design of tables, queries, forms, reports, and data access pages. In addition, it is designed for those pursuing core-level Microsoft Office User Specialist (MOUS) certification in Access 2002.
Prerequisites:	Introduction to Access 2002 or equivalent experience
Length:	One day

Managing a Database and Data
• Import Data
• Maintain Record Integrity
• Exporting Data
• Documenting Table Relationships

Controlling Data Entry
• Make Data Entry More Accurate
• Make Data Entry More Efficient
• Facilitate Data Entry

Finding and Joining Data
• Find Data with Filters
• Get the Correct Data with Query Joins
• Building Bridges Between the Data
• Relating Data Within a Table

Creating Flexible Queries
• Summarizing Data with Queries
• Enter Criteria on the Fly
• Maintain Data with Queries

Improving Your Forms
• Enhance the Appearance of a Form
• Enhance the Usability of a Form
• Make Your Forms More Professional
• Display Form Data from Multiple Tables

Customizing Your Reports
• Organize Report Information
• Enhance Data Layout
• Working with Report Pagination
• Summarizing Information
• Add a Subreport to an Existing Report
• Creating Mailing Labels

Making Your Data Available on the Web
• Create a Data Access Page
• Improving the Look of a Data Access Page
• Editing Data Using a Data Access Page
• Group Records in a Data Access Page

Summary and Review