Access 2007 Intermediate - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this training class, students will be able to:

  • Modify the design and field properties of a table to streamline data entry and maintain data integrity
  • Retrieve data from tables using joins
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
  • Enhance the capabilities of a form
  • Customize reports to organize the displayed information and produce specific print layouts
  • Share data across different applications

Course Content

Lesson 1: Controlling Data Entry

  1. Restrict Data Entry Using Field Properties
  2. Establish a Pattern for Entering Field Values
  3. Create a List of Values for a Field

Lesson 2: Joining Tables

  1. Create Query Joins
  2. Join Unrelated Tables
  3. Relate Data Within a Table

Lesson 3: Creating Flexible Queries

  1. Set Select Query Properties
  2. Create Parameter Queries
  3. Create Action Queries

Lesson 4: Improving Forms

  1. Design a Form Layout
  2. Enhance the Appearance of a Form
  3. Restrict Data Entry in Forms
  4. Add a Command Button to a Form
  5. Create a Subform

Lesson 5: Customizing Reports

  1. Organize Report Information
  2. Format the Report
  3. Set Report Control Properties
  4. Control Report Pagination
  5. Summarize Report Information
  6. Add a Subreport to an Existing Report
  7. Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

  1. Import Data into Access
  2. Export Data
  3. Analyze Access Data in Excel
  4. Export Data to a Text File
  5. Merge Access Data with a Word Document

If you would like to customize this training class, please contact us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!