access 2007 unit d
DESCRIPTION
TRANSCRIPT
Microsoft Office 2007- Illustrated Introductory, Microsoft Office 2007- Illustrated Introductory, Windows Vista EditionWindows Vista Edition
Using ReportsUsing Reports
ObjectivesObjectives
• Preview a reportPreview a report
• Use the Report WizardUse the Report Wizard
• Use Report Design ViewUse Report Design View
• Use report sectionsUse report sections
(continued)(continued)
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 2
Objectives Objectives
• Add subtotals and countsAdd subtotals and counts
• Resize and align controlsResize and align controls
• Format a reportFormat a report
• Change page layoutChange page layout
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 3
Previewing a ReportPreviewing a Report
• The report feature helps you create a The report feature helps you create a professional-looking, easy-to-read professional-looking, easy-to-read document that summarizes datadocument that summarizes data
• Reports are Reports are read-onlyread-only objects objects
• Report sections determine where and Report sections determine where and when controls print in the reportwhen controls print in the report
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 4
Report SectionsReport Sections
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 5
Using the Report WizardUsing the Report Wizard
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Report Wizard is one way to create a Report Wizard is one way to create a reportreport
• It is a tool that asks you questions to It is a tool that asks you questions to guide development of the reportguide development of the report
• Your responses determine record Your responses determine record source, style and layoutsource, style and layout
• The Wizard helps sort, group and The Wizard helps sort, group and analyze recordsanalyze records
6
Report WizardReport Wizard
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 7
Using Report Design ViewUsing Report Design View
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Report Design View is another way Report Design View is another way to create a reportto create a report
• It is not quite as simple as Report It is not quite as simple as Report Wizard but it allows more changesWizard but it allows more changes
8
Report Design ViewReport Design View
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 9
Adding fields toAdding fields toReport Design ViewReport Design View
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 10
Using Report SectionsUsing Report Sections
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• A section determines where and how A section determines where and how often controls in that section print in often controls in that section print in the reportthe report
• Grouping means to sort records in a Grouping means to sort records in a specific order specific order plusplus provide a header provide a header or footer section after each groupor footer section after each group
11
Using Report SectionsUsing Report Sections
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 12
Adding Subtotals and CountsAdding Subtotals and Counts
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Calculations are used to add Calculations are used to add subtotals and counts to a reportsubtotals and counts to a report
• Expressions are needed to create a Expressions are needed to create a calculationcalculation
• Functions are built-in Access Functions are built-in Access formulasformulas
• Arguments are information needed Arguments are information needed by a functionby a function
13
Examples of Access ExpressionsExamples of Access Expressions
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition 14
Resizing and Aligning ControlsResizing and Aligning Controls
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• You can resize a control by using the You can resize a control by using the ↔ pointer↔ pointer
• After resizing a control, it may need After resizing a control, it may need to be realignedto be realigned
• Two ways to align controls:Two ways to align controls:
* Within its own border* Within its own border
* With respect to each other* With respect to each other
15
Precise Resizing and AligningPrecise Resizing and Aligning
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• [Ctrl] + arrow key(s) [Ctrl] + arrow key(s) movemove a control a control one pixel at a timeone pixel at a time
• [Shift] + arrow key(s) [Shift] + arrow key(s) resizeresize a control a control one pixel at a timeone pixel at a time
• Pixel:Pixel:
* pix = picture* pix = picture
* el = element* el = element
16
Formatting a ReportFormatting a Report
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Formatting can make a report look Formatting can make a report look more professional and easier to readmore professional and easier to read
• Formatting includes:Formatting includes:
* Font style, size and color* Font style, size and color
* Background colors* Background colors
* Line thickness and color* Line thickness and color
* Alignment* Alignment
17
Typical Formatting CommandsTypical Formatting Commands
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
18
Changing Page LayoutChanging Page Layout
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Altering the layout can make a report Altering the layout can make a report fit better on the page, making it fit better on the page, making it easier to readeasier to read
• Page layout includes:Page layout includes:
* Orientation (portrait or landscape)* Orientation (portrait or landscape)
* Margins* Margins
• Remember to use Print PreviewRemember to use Print Preview
19
Page OrientationPage Orientation
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Portrait:Portrait:
• Landscape: Landscape:
20
Page Layout ButtonsPage Layout Buttons
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
21
SummarySummary
Microsoft Office 2007-Illustrated Introductory, Windows Vista Edition
• Build reports to summarize and Build reports to summarize and professionally present informationprofessionally present information
• Report sections determine where and Report sections determine where and how often the controls within them are how often the controls within them are printedprinted
• Add calculations using text boxes that Add calculations using text boxes that contain expressionscontain expressions
• Align and format controls to improve Align and format controls to improve the appearance of the reportthe appearance of the report
22