Access 2007: Intermediate

Course Specifications:

Courseware: Microsoft Office Access 2007: Level 2

Software: Access 2007

Course length: 1 day

Course Description:

In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Course Objective:

You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Access 2007 with other applications.

Target Student:

This course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications.

Prerequisites:

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

  1. Access 2007: 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: Controlling Data Entry

  1. Topic 1A: Restrict Data Entry Using Field Properties
  2. Topic 1B: Establish a Pattern for Entering Field Values
  3. Topic 1C: Create a List of Values for a Field

Lesson 2: Joining Tables

  1. Topic 2A: Create Query Joins
  2. Topic 2B: Join Unrelated Tables
  3. Topic 2C: Relate Data Within a Table

Lesson 3: Creating Flexible Queries

  1. Topic 3A: Set Select Query Properties
  2. Topic 3B: Create Parameter Queries
  3. Topic 3C: Create Action Queries

Lesson 4: Improving Forms

  1. Topic 4A: Design a Form Layout
  2. Topic 4B: Enhance the Appearance of a Form
  3. Topic 4C: Restrict Data Entry in Forms
  4. Topic 4D: Add a Command Button to a Form
  5. Topic 4E: Create a Subform

Lesson 5: Customizing Reports

  1. Topic 5A: Organize Report Information
  2. Topic 5B: Format the Report
  3. Topic 5C: Set Report Control Properties
  4. Topic 5D: Control Report Pagination
  5. Topic 5E: Summarize Report Information
  6. Topic 5F: Add a Subreport to an Existing Report
  7. Topic 5G: Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

  1. Topic 6A: Import Data into Access
  2. Topic 6B: Export Data
  3. Topic 6C: Analyze Access Data in Excel
  4. Topic 6D: Export Data to a Text File
  5. Topic 6E: Merge Access Data with a Word Document