Microsoft office 2007 illustrated introductory windows vista edition
This presentation is the property of its rightful owner.
Sponsored Links
1 / 22

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


  • 80 Views
  • Uploaded on
  • Presentation posted in: General

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.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


Microsoft office 2007 illustrated introductory windows vista edition

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition

Using Reports


Objectives

Objectives

  • 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

  • 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

  • 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

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using the report wizard

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


Report wizard

Report Wizard

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using report design view

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


Report design view

Report Design View

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Adding fields to report design view

Adding fields toReport Design View

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Using report sections

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


Using report sections1

Using Report Sections

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Adding subtotals and counts

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


Examples of access expressions

Examples of Access Expressions

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Resizing and aligning controls

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


Precise resizing and aligning

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


Formatting a report

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


Typical formatting commands

Typical Formatting Commands

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Changing page layout

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


Page orientation

Page Orientation

  • Portrait:

  • Landscape:

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Page layout buttons

Page Layout Buttons

Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition


Summary

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


  • Login