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 • Create a Donation Summary report using both tables • View by Donation • Group by quarter • Change to “by Month” – note that headers are not changed

6. More Complex Reports (cont’d) • Want page breaks? • Insert where you want it • View in Print Preview • Modify the report to select only 1/1/14 – 1/31/14 • Select the report Properties • Click on the Data tab…

7. More Complex Reports (cont’d) • Click on the … by the Record Source • Add Criteria to the appropriate fields • Save the Query and rerun the report • Save the report

8. What’s Next? • Customizing • Custom forms • Custom reports • More complex queries