Introduction to Microsoft Access
Topic 7 - Creating Reports with Access
- 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
- Report Wizard
- AutoReport
- Report Header
- Page Header
- Detail
- Page Footer
- Report Footer
- decide page size
- set report width
- set page margins
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)
- SUM, AVG, MAX, MIN
- Use the Report Header or Report Footer sections
- Can use text with the statistical expression
- note - you don't even need to show the data