microsoft office 2007- illustrated introductory, windows ... · microsoft office 2007-illustrated...
TRANSCRIPT
Objectives
• Preview a report
• Use the Report Wizard
• Use Report Design View
• Use report sections
(continued)
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 2
Objectives
• Add subtotals and counts
• Resize and align controls
• Format a report
• Change page layout
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 3
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 4
Using the Report Wizard
Microsoft Office 2007-Illustrated Introductory, Windows 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
6
Using Report Design View
Microsoft Office 2007-Illustrated Introductory, Windows 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
8
Adding fields to
Report Design View
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 10
Using Report Sections
Microsoft Office 2007-Illustrated Introductory, Windows 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
11
Adding Subtotals and Counts
Microsoft Office 2007-Illustrated Introductory, Windows 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
13
Examples of Access Expressions
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 14
Resizing and Aligning Controls
Microsoft Office 2007-Illustrated Introductory, Windows 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
15
Precise Resizing and Aligning
Microsoft Office 2007-Illustrated Introductory, Windows 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
16
Formatting a Report
Microsoft Office 2007-Illustrated Introductory, Windows 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
17
Typical Formatting Commands
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
18
Changing Page Layout
Microsoft Office 2007-Illustrated Introductory, Windows 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
19
Page Orientation
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Portrait:
• Landscape:
20
Summary
Microsoft Office 2007-Illustrated Introductory, Windows 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
22