Access 2003 Designing Advanced Reports

Objective

Learn to create a report from the Design view, use subreports, create calculations, and define multi-column reports. Also learn to create reports using charts and crosstab reports.

Prerequisite Skills

Comfortable creating and working with Access databases and tables.
(Suggested courses: Access 2003 Getting Started with Databases & Tables, Access 2003 Making the Most of Tables, and Access 2003 Working with Table Relationships)
Comfortable with simple Access queries
(Suggested course: Access 2003 Queries I)
Comfortable creating basic reports and forms in Access
(Suggested course: Access 2003 Working with Reports, Access 2003 Creating Forms, and Access 2003 Enhancing Forms)

Course Description

Do you want to create a more customized report to meet more specific needs? Do you want to use subreports, create calculations in a report, or group and sort the information in a report?

Attend this course if you want to:

Learn to create reports using the Design view.
Use the grid to place, move, align, and resize controls with precision.
Sort or group the information in a report to control how it displays.
Create subreports and subforms (reports within a report).
Use expressions to display a date, page number, or calculation in a report.
Add a chart to a report.
Create a crosstab report.
Print multiple report columns on a page.
Create report snapshots so that users without Access can view your report.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)