microsoft office 2007 illustrated introductory windows vista edition
Download
Skip this Video
Download Presentation
Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition

Loading in 2 Seconds...

play fullscreen
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
  • 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

ad