MicroKnowledge Computer Training and Consulting Access 2007 Report Design

Access 2007 Report Design

Create and enhance reports using Access. Participants will produce effective reports utlizing features available in Layout View and Design View. Topics include formatting, creating calculations, customizing headers and footers, generating mailing lables, printing and exporting and linking queries to reports.

Recommended Preparation: Access 2007 Basic or equivalent experience.

Lesson 1: Using Layout View

Creating reports in Layout View
Changing fonts and text styles
Using conditional formatting
Formatting reports
Adding and arranging fields
Reporting from related tables
Adding grouping, subtotals, and grand totals

Lesson 2: Using Design View

Creating reports in Design View
Creating custom headers/footers
Creating calculations and unbound objects
Arranging, aligning, and sizing controls

Lesson 3: Adjusting Page Layout and Printing

Page setup and margins
Changing custom group properties
Printing reports
Exporting reports to Word
Creating Mailing Labels

Lesson 4: Using Queries for Effective Reports

Using queries as a record source
Filtering reports using parameter values