Access 2003 - Reports Advanced
ACC-03-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:
- ACC-03-01 - Introduction
- ACC-03-02 - Using Forms and Data Input
- ACC-03-03 - Form Design Basic
- ACC-03-04 - Queries Basic
- ACC-03-05 - Reports Basic
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.
