90 likes | 252 Views
Access Reports. Reports. Enable printed or screen output Can generate many different reports from a single table or database Are easy to create with wizards. Types of reports. Columnar (vertical) – looks like repeated forms Tabular – field names across the top, data in columns
E N D
Reports • Enable printed or screen output • Can generate many different reports from a single table or database • Are easy to create with wizards
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
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
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
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…
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
What’s Next? • Customizing • Custom forms • Custom reports • More complex queries