Access 2002 : Level 2

Course Description

Overview: Students will be able to create, revise, and customize the design of tables, queries, forms, reports, and data access pages.

Prerequisites: Windows 2000: Introduction; Access 2002: Level 1 or have equivalent knowledge:

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• share data with other applications and enforce referential integrity.
• modify the design of a table to streamline data entry and maintain data integrity.
• use a filter to show records that match criteria and generate different query results by creating different types of joins between tables.
• create select queries that display special records and design other types of queries, including parameter and action queries.
• create forms and change their designs to enhance the appearance and usability of a form, and to make your form more professional.
• create reports and change their designs to better organize and summarize information, and to improve the appearance by enhancing data layout and working with report pagination.
• create, modify, and work with data access pages.

Course Content

Lesson 1: Managing a Database and Data

Import Data

Maintain Record Integrity

Exporting Data

Documenting Table Relationships

Lesson 2: Controlling Data Entry

Make Data Entry More Accurate

Make Data Entry More Efficient

Facilitate Data Entry

Lesson 3: 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

Lesson 4: Creating Flexible Queries

Summarizing Data with Queries

Enter Criteria on the Fly

Maintain Data with Queries

Lesson 5: 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

Lesson 6: 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

Lesson 7: 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 AccessPage