Microsoft Office 2007- Illustrated Introductory, Windows XP Edition

1. Microsoft Office 2007- Illustrated Introductory, Windows XP 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 XP Edition

3. Objectives • Add subtotals and counts • Resize and align controls • Format a report • Change page layout Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

5. Report Sections Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

7. Report Wizard Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

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

10. Adding fields toReport Design View Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

12. Using Report Sections Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

14. Examples of Access Expressions Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP 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 XP 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 XP Edition

18. Typical Formatting Commands Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition

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

21. Page Layout Buttons Microsoft Office 2007-Illustrated Introductory, Windows XP 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 XP Edition