220 likes | 231 Views
Microsoft Office 2007- Illustrated Introductory, Windows XP 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
E N D
Microsoft Office 2007- Illustrated Introductory, Windows XP Edition Using Reports
Objectives • Preview a report • Use the Report Wizard • Use Report Design View • Use report sections (continued) Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
Objectives • Add subtotals and counts • Resize and align controls • Format a report • Change page layout Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Report Sections Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Report Wizard Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Report Design View Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
Adding fields toReport Design View Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Using Report Sections Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Examples of Access Expressions Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
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
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
Typical Formatting Commands Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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
Page Orientation • Portrait: • Landscape: Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
Page Layout Buttons Microsoft Office 2007-Illustrated Introductory, Windows XP Edition
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