1 / 22

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition. Using Reports. Objectives. Preview a report Use the Report Wizard Use Report Design View Use report sections (continued). Objectives. Add subtotals and counts Resize and align controls Format a report

Download Presentation

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition

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. Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition Using Reports

  2. Objectives • Preview a report • Use the Report Wizard • Use Report Design View • Use report sections (continued) Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  3. Objectives • Add subtotals and counts • Resize and align controls • Format a report • Change page layout Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  4. Previewing a Report • The report feature helps you create a professional-looking, easy-to-read document that summarizes data • Reports are read-only objects • Report sections determine where and when controls print in the report Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  5. Report Sections Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  6. Using the Report Wizard • Report Wizard is one way to create a report • It is a tool that asks you questions to guide development of the report • Your responses determine record source, style and layout • The Wizard helps sort, group and analyze records Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  7. Report Wizard Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  8. Using Report Design View • Report Design View is another way to create a report • It is not quite as simple as Report Wizard but it allows more changes Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  9. Report Design View Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  10. Adding fields toReport Design View Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  11. Using Report Sections • A section determines where and how often controls in that section print in the report • Grouping means to sort records in a specific order plus provide a header or footer section after each group Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  12. Using Report Sections Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  13. Adding Subtotals and Counts • Calculations are used to add subtotals and counts to a report • Expressions are needed to create a calculation • Functions are built-in Access formulas • Arguments are information needed by a function Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  14. Examples of Access Expressions Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  15. Resizing and Aligning Controls • You can resize a control by using the ↔ pointer • After resizing a control, it may need to be realigned • Two ways to align controls: * Within its own border * With respect to each other Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  16. Precise Resizing and Aligning • [Ctrl] + arrow key(s) move a control one pixel at a time • [Shift] + arrow key(s) resize a control one pixel at a time • Pixel: * pix = picture * el = element Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  17. Formatting a Report • Formatting can make a report look more professional and easier to read • Formatting includes: * Font style, size and color * Background colors * Line thickness and color * Alignment Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  18. Typical Formatting Commands Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  19. Changing Page Layout • Altering the layout can make a report fit better on the page, making it easier to read • Page layout includes: * Orientation (portrait or landscape) * Margins • Remember to use Print Preview Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  20. Page Orientation • Portrait: • Landscape: Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  21. Page Layout Buttons Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

  22. Summary • Build reports to summarize and professionally present information • Report sections determine where and how often the controls within them are printed • Add calculations using text boxes that contain expressions • Align and format controls to improve the appearance of the report Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition

More Related