iCellini Computer Training

San Diego’s Onsite Computer Training Company

home icon email icon

Microsoft Access 2007, Class 2

Duration: 1 day (about 6 hours)
Prerequisite: Microsoft Access 2007 Introduction or equivalent experience
Course Materials: Course manual with CD containing exercises
Prices: $225 for 1 student (one-on-one training)
$160 each for 2 to 3 students
$130 each for 4 to 6 students
$130 for the first 6 students, $100 for each additional student
Description: Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications.

Controlling Data Entry

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

Joining Tables

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Improving Forms

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

Customizing Reports

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Sharing Data Across Applications

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

Top of Page

Microsoft Access 2007, Class 3

Return to Microsoft Access list of classes