Access 2007 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 2007 Getting Started, Access 2007 Making the Most of Tables, and Access 2007 Working with Table Relationships)
Comfortable with simple Access queries
(Suggested course: Access 2007 Queries I)
Comfortable creating basic reports and forms in Access
(Suggested course: Access 2007 Working with Reports, Access 2007 Creating Forms, and Access 2007 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 work with reports in the Design view.
Hide duplicate values in a report.
Sort or group the information in a report to control how it displays.
Use expressions to display a date, page number, or calculation in a report.
Number the records in a report.
Print multiple report columns on a page.
Apply conditional formatting to a report.
Add a chart to a report.
Create subreports within a 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)