Access 2007 Level 2

1 Day Course
Hands On
Code DAC07L2

This course has been retired. Please view currently available User Microsoft Office Training Courses.


Collapse all

Controlling Data Entry (3 topics)

  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field

Joining Tables (3 topics)

  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table

Creating Flexible Queries (3 topics)

  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries

Improving Forms (5 topics)

  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform

Customising Reports (7 topics)

  • Organise Report Information
  • Format the Report
  • Set Report Control Properties
  • Control Report Pagination
  • Summarise Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report

Sharing Data Across Applications (5 topics)

  • Import Data into Access
  • Export Data
  • Analyse Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document

Course PDF