MicroKnowledge Access 2003 Advanced Reports Micro-Session

Access 2003 Report Design

Creation of functional reports from queries. Including grouping, summary information, calculations, sub-reports, charts, parameter values used to generate specific reports, and exporting reports to MS Word & Excel.

Recommended Preparation: Access 2003 Basic or equivalent experience.

Lesson 1: Report Design

Creating Reports in Design View
Creating Custom Headers / Footers
Creating and Using Grouping
Creating Calculations and Unbound Objects
Creating Lines / Boxes
Creating Sub Totals and Grand Totals
Formatting Reports

Lesson 2: Working with Properties and Parameter Values

Setting Page Properties and Margins
Form Properties / Section Properties
Using Parameter Values in
Queries for Reports (Date Range)

Lesson 3: Sub Reports, Charts and Exporting

Creating Sub-reports
Using Can Grow / Can Shrink Properties
Creating Charts in Reports
Exporting Reports to Word/Excel
Naming Objects (Best Practices)