Access 2002: Intermediate

Course Specifications:

Courseware: Access 2002: Level 2

Software: Microsoft Office XP Professional

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

As you begin this course, you should have the basic skills you need to design and create relational databases with Access. This course covers many intermediate-level skills, particularly those related to creating more complex queries, customizing your forms and reports, and broadening the availability of your data.

Course Objective:

You will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages.

Target Student:

This course targets persons who use Access 2002 as a tool for getting their work done. Your responsibilities might include creating and/or revising the design of tables, queries, forms, reports, and data access pages. This course also serves as a prerequisite for persons interested in learning more advanced skills and features.

Prerequisites:

To ensure the successful completion of Access 2002: Intermediate, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

1. Windows 2000: Introduction
2. Access 2002: Introduction

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Managing a Database and Data

1. Topic 1A: Import Data
2. Topic 1B: Maintain Record Integrity
3. Topic 1C: Exporting Data
4. Topic 1D: Documenting Table Relationships

Lesson 2: Controlling Data Entry

1. Topic 2A: Make Data Entry More Accurate
2. Topic 2B: Make Data Entry More Efficient
3. Topic 2C: Facilitate Data Entry

Lesson 3: Finding and Joining Data

1. Topic 3A: Find Data with Filters
2. Topic 3B: Get the Correct Data with Query Joins
3. Topic 3C: Building Bridges Between the Data
4. Topic 3D: Relating Data within a Table

Lesson 4: Creating Flexible Queries

1. Topic 4A: Summarizing Data with Queries
2. Topic 4B: Enter Criteria on the Fly
3. Topic 4C: Maintain Data with Queries

Lesson 5: Improving Your Forms

1. Topic 5A: Enhance the Appearance of a Form
2. Topic 5B: Enhance the Usability of a Form
3. Topic 5C: Make Your Forms More Professional
4. Topic 5D: Display Form Data from Multiple Tables

Lesson 6: Customizing Your Reports

1. Topic 6A: Organize Report Information
2. Topic 6B: Enhancing Data Layout
3. Topic 6C: Working with Report Pagination
4. Topic 6D: Summarizing Information
5. Topic 6E: Add a Subreport to an Existing Report
6. Topic 6F: Creating Mailing Labels

Lesson 7: Making Your Data Available on the Web

1. Topic 7A: Create a Data Access Page
2. Topic 7B: Improving the Look of a Data Access Page
3. Topic 7C: Editing Data Using a Data Access Page
4. Topic 7D: Group Records in a Data Access Page