Access 2010 - Reports Advanced

ACC-10-09

Duration

Half day

Who should attend?

Anyone who needs to create more complex reports to perform tasks such as summarising data from different tables, creating subreports and reports with parameters.

Pre-requisites

Familiarity with the topics covered in modules:

Objectives

To design more powerful reports.

Course Content

Properties

A detailed look at the report and report section properties. Keep data on same page, page breaks.

Calculations

The banding of calculations. Basic calculations. DSum/DMin/DMax/DAvg

Summary Reports

Group and summarise data from different tables.

Subreports

Insert a report within another report. Bound and unbound subreports.

Charts

Present data graphically within the report.