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