Day 19: Access Chapter 4

1. Day 19:Access Chapter 4 Larry Reaveslarry.reaves@mail.wvu.edu October 23, 2013

2. Last class • Forms • Design View • Layout View • Form View • Form Wizard • Split Forms • Multiple Item Forms • Datasheet Forms

3. Reports • A report is a printable document that displays information in the database in a easy to read format • Reports allow you to customize what data is displayed and how it is displayed

4. Creating Basic reports • Create->Reports • Report • Report Deisgn/Blank Report • Report Wizard

5. Create->Reports->Report • Creates a simple report for the currently selected table or query • Unlike the form tool, the report tool does not pull in related table information

6. Create->Reports->Report Design • Report Design and Blank Report both create empty reports so you can build your report from scratch • Report Design opens the empty report in Design View • Blank Report opens the empty report in Layout View

7. Create->Reports->Report Wizard • The report wizard allows you to easily create reports that use data from multiple tables or queries • Like the forms, data can be grouped on the reports based on established relationships

8. Label Wizard • Create->Reports->Labels • Allows you to create mailing labels, name tags, or any other specialized labels based on the data in your database

9. Working with reports • Adding fields • Deleting fields • Report layout control • Adjusting column widths • Themes

10. Sorting • While sorting can be set up in the report wizard, it can also be altered later, or set up for reports created without the wizard • Report Layout Tools->Design->Grouping & Totals->Group & Sort

11. Report sections • Like forms, reports also have sections • Reports have multiple sets of headers and footers… one for the entire report, one for each page • Additionally there is a header and a footer for each grouping

12. Group totals • Often you need to add totals, averages, or other aggregations for each group in a report • Report Design/Layout Tools->Design->Grouping & Totals->Totals

13. Print Preview • Since reports are usually meant to be printed, they have an additional view that isn’t available for forms: print preview • If you will be printing your report, be sure to check your design in print preview to see how it will translate to a physical report

14. In Class project

15. Next Class • Data Validation • Required Fields • Default Values • Validation Rules • Input Masks