|
Duration:
Instructor-led Classroom Learning - 2.00 Day(s)
Online Anytime - Self Paced
Mentored Learning - Flexible
Overview:
In this course, students will build basic list and group reports that
work with almost any database.
Who Should Attend:
This course is designed for a person who needs output from a database.
In some cases, database programs have limited reporting tools, and/or
they may not have access to those tools. Students may or may not have
programming and/or SQL experience.
At Course Completion:
Upon successful completion of this course, students will be able to: -
create a report by using data from an existing database. - use a report
to present specific data in the desired order. - create groups to
summarize report data. - build formulas to calculate and display data. -
format reports. - add and modify elements in a report. - create single
data series charts. - distribute report data.
|
| Prerequisite(s) or equivalent knowledge:
|
Access 2003 - Level 1
|
| |
| Outline: |
| Lesson 1: Creating a Report |
Set Default Report Settings
Specify Fields for a New Report
Preview a Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Other Tables
|
| Lesson 2: Displaying Specific Report Data |
Find Data
Sort Data
Filter Data by a Single Criterion
|
| Lesson 3: Grouping Report Data |
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add a Second-Level Grouping
Filter Records by Group
Create a Top N Sort Group
|
| Lesson 4: Building Formulas |
Create a Formula
Edit a Formula
Combine Fields by Formula
Delete a Formula
Filter Data by Multiple Criteria
Modify a Filter Using an OR Operator
Create a Parameter Field
Account for Null Fields in a Formula
|
| Lesson 5: Formatting Reports |
Remove White Space
Insert Page Header/Footer Data
Add Borders, Boxes, and Lines
Change Field Background Color
Change the Margins
|
| Lesson 6: Enhancing Reports |
Add a Watermark
Insert Objects Using Object Linking and Embedding
Modify Formatting Based on Data Value
Suppress Report Sections
Insert Hyperlinks
Hide Blank Report Sections
|
| Lesson 7: Creating Pie Charts |
Create a Pie Chart with a Drill-Down
Modify Chart Text
Format a Chart
Present a Chart by Group
|
| Lesson 8: Distributing Data |
Export to a PDF File
Export to a Microsoft Excel File
Export to an Access Database File
Export a Report Definition
Create Mailing Labels |
Add to favorites
Email this page
On-Site Training
Seminar
