Access Reports

1
Access Reports
2
Reports

• Enable printed or screen output
• Can generate many different reports from a single
  table or database
• Are easy to create with wizards

3
Types of reports

• Columnar (vertical) looks like repeated forms
• Tabular field names across the top, data in
  columns
• Groups, totals, and summaries like tabular with
  breaks
• Mailing labels

4
Report Wizard

• Start with the wizard, then modify
• Create a simple report for the Contacts table
• Sort by LastName, then by FirstName
• Create a report for the Donations table and group
  by ContactID

5
More Complex Reports

• Can get data from multiple tables
• Create a Donation Summary report using both
  tables
• View by Donation
• Group by quarter

6
More Complex Reports (contd)

• Notice we need page breaks (use toolbox)
• Modify the report to select only 2/3/08 2/5/08
• Select the report Properties
• Click on the Data tab

7
More Complex Reports (contd)

• Click on the by the Record Source
• Add Criteria to the appropriate fields
• Save the Query and rerun the report

8
Modifying Reports

• Reports are modified like forms
• Change the look with Format, Autoformat

9
Whats Next?

• Customizing
• Custom forms
• Custom reports
• More design examples

10
(No Transcript)