Access Introduction to Microsoft Access
Topic 7 - Creating Reports with Access


7.1 Introduction

- Access includes a great "Report Writer"
- For the purpose of this class, Forms are similar to Reports
- Set up the data source for the report first
- Views: Design View and Print Preview View

7.2 Other Methods to Create a Report

- Report Wizard
- AutoReport

7.3 The Design Window Report Parts

- Report Header
- Page Header
- Detail
- Page Footer
- Report Footer

7.4 Initial Report Setup

- decide page size
- set report width
- set page margins

7.5 Adding and Modifying Report Controls

7.5.1 Controls Covered in this Class

Label, Text Box, Line

7.5.2 Control Size and Position

- resizing controls
- moving controls

7.5.3 Some Control Formats

- Formatting Toolbar includes Font, Size, Color, Alignment

7.5.4 The Properties Window

- use to set a control's attributes
- how to define a control's position (left, top)

7.6 Using Reports to Perform Statistical Calculations

- SUM, AVG, MAX, MIN
- Use the Report Header or Report Footer sections
- Can use text with the statistical expression

7.7 Grouped Reports

7.8 Calculations in Grouped Reports

- note - you don't even need to show the data