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

Loading...

PPT – Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition PowerPoint presentation | free to view - id: 59df2d-ZTNlM



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition

Description:

Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition Using Reports Objectives Preview a report Use the Report Wizard Use Report Design View Use ... – PowerPoint PPT presentation

Number of Views:119
Avg rating:3.0/5.0
Slides: 23
Provided by: rpad7
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Microsoft Office 2007- Illustrated Introductory, Windows Vista Edition


1
Microsoft Office 2007- Illustrated Introductory,
Windows Vista Edition
  • Using Reports

2
Objectives
  • Preview a report
  • Use the Report Wizard
  • Use Report Design View
  • Use report sections
  • (continued)

3
Objectives
  • Add subtotals and counts
  • Resize and align controls
  • Format a report
  • Change page layout

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

5
Report Sections
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

7
Report Wizard
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

9
Report Design View
10
Adding fields toReport Design View
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

12
Using Report Sections
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

14
Examples of Access Expressions
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

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

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

18
Typical Formatting Commands

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

20
Page Orientation
  • Portrait
  • Landscape

21
Page Layout Buttons

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
About PowerShow.com