1 / 16

Mastering Report Creation in Database Design: A Comprehensive Guide

This lesson covers essential aspects of creating and managing reports in a database environment. Learn various report types including basic and custom reports, using tools like the Report Wizard and Design View. Gain insights on adding and deleting fields, adjusting layouts, and implementing sorting. Understand the significance of headers, footers, and group totals in reports. This guide is tailored for those looking to enhance their skills in database reporting and presentation for efficient data management.

reina
Télécharger la présentation

Mastering Report Creation in Database Design: A Comprehensive Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related