Microsoft office 2007 illustrated introductory windows vista edition
Download
1 / 22

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition - PowerPoint PPT Presentation


  • 110 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition' - griffin-parrish


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Objectives
Objectives Vista Edition

  • Preview a report

  • Use the Report Wizard

  • Use Report Design View

  • Use report sections

    (continued)

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Objectives1
Objectives Vista Edition

  • Add subtotals and counts

  • Resize and align controls

  • Format a report

  • Change page layout

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Previewing a report
Previewing a Report Vista Edition

  • 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


Report sections
Report Sections Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using the report wizard
Using the Report Wizard Vista Edition

  • 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


Report wizard
Report Wizard Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using report design view
Using Report Design View Vista Edition

  • 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


Report design view
Report Design View Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Adding fields to report design view
Adding fields to Vista EditionReport Design View

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using report sections
Using Report Sections Vista Edition

  • 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


Using report sections1
Using Report Sections Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Adding subtotals and counts
Adding Subtotals and Counts Vista Edition

  • 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


Examples of access expressions
Examples of Access Expressions Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Resizing and aligning controls
Resizing and Aligning Controls Vista Edition

  • 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


Precise resizing and aligning
Precise Resizing and Aligning Vista Edition

  • [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


Formatting a report
Formatting a Report Vista Edition

  • 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


Typical formatting commands
Typical Formatting Commands Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Changing page layout
Changing Page Layout Vista Edition

  • 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


Page orientation
Page Orientation Vista Edition

  • Portrait:

  • Landscape:

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Page layout buttons
Page Layout Buttons Vista Edition

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Summary
Summary Vista Edition

  • 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