Course Name

Overview

Upon successful completion of this course, students will be able to:

• Create a report by using data from an existing database.
  
• Locate and present data in a specified order.
  
• Create groups to summarize report data.
  
• Build formulas to add non-database data to a report and display data differently.
  
• Format reports.
  
• Enhance reports by adding and modifying elements in a report.
  
• Create single data series charts.
  Distribute report data to other users.
  

Course content

Lesson 1: Creating a List Report
Set Default Report Settings
Specify Fields for a New Report
Preview the Report
Modify Field Display
Add a Report Title
Position Fields
Add Fields from Additional Tables

Lesson 2: Displaying Specific Report Data
Find Data
Sort Data
Filter Data by Single Criteria

Lesson 3: Grouping Report Data
Insert a Group
Add Summaries
Format Summary Information
Change Group Options
Add an Additional Group
Filter by Group
Create a Top N Sort Group

Lesson 4: Building Formulas
Write a Formula
Edit a Formula
Group by Formula
Delete a Formula
Build a Filter by Multiple Criteria
Modify a Filter with Multiple Criteria to Create an OR Condition
Create a Parameter Field
Write a Formula that Incorporates Null Fields

Lesson 5: Formatting Reports
Remove White Space
Insert Page Header/Footer Data
Add Borders and Lines
Change the Background Color
Change the Margins

Lesson 6: Enhancing Reports
Create a Section to Contain a Watermark
Insert Objects Using Object Linking and Embedding
Modify Format Based on Data Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Blank Report Sections

Lesson 7: Creating and Modifying Pie Charts
Create a Pie Chart with a Drill-down
Change the Chart Title
Format a Chart
Present a Chart by Group

Lesson 8: Distributing Data
Export to PDF
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels