Access 2010 Enhancing Reports

Objective

Learn to enhance a report by filtering, sorting, grouping, and totaling it, changing its layout, and adding enhanced controls to the report, such as subreports and charts. Also learn to apply conditional formatting to a report.

Prerequisite Skills

Comfortable creating and working with Access databases, tables, and queries.
(Suggested courses: Access 2010 Getting Started, Access 2010 Creating Tables, Access 2010 Enhancing Tables, Access 2010 Working with Table Relationships, Access 2010 Creating Select Queries, and Access 2010 Creating Advanced Queries)
Comfortable with forms and basic reports in Access
(Suggested courses: Access 2010 Creating Forms, Access 2010 Enhancing Forms, and Access 2010 Creating Reports)

Course Description

Do you want more control over the way a report is arranged? Do you want to group, sort, and total information in a report? Do you want to format report data based on specific criteria?

Attend this course if you want to:

Work with reports in Report view.
Change the tab order of a report.
Find a specific value in a report.
Filter a report to locate records that meet specific criteria.
Use layouts to arrange report controls.
Display a printed report in multiple columns.
Sort, group, and total a report.
Add text boxes, hyperlinks, subreports, and charts to a report.
Control where page breaks occur in a report.
Apply conditional formatting to 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)