LEVEL 1
|
LEVEL 2
|
|
Lesson 1:
Creating a Report |
Lesson 1:
Creating Running Totals |
|
Topic 1A: Set
Default Report Settings |
Topic 1A: Create
a Running Total Field |
|
Topic 1B:
Specify Fields for a New Report |
Topic 1B: Modify
a Running Total Field |
|
Topic 1C:
Preview the Report |
Topic 1C: Create
a Manual Running Total on Detail Data |
|
Topic 1D: Modify
Field Display |
Topic 1D: Create
a Manual Running Total on Summary Data |
|
Topic 1E: Add a
Report Title |
|
|
Topic 1F:
Position Fields |
Lesson 2:
Building Cross-tabs in Your Report |
|
Topic 1G: Add
Fields from Additional Tables |
Topic 2A: Create
a Cross-tab |
|
|
Topic 2B: Create
a Specified Group Order |
|
Lesson 2:
Displaying Specific Report Data |
Topic 2C: Filter
a Cross-tab by Group |
|
Topic 2A: Find
Data |
Topic 2D: Change
the Cross-tab Format |
|
Topic 2B: Sort
Data |
Topic 2E:
Conditionally Format Rows and Columns |
|
Topic 2C: Filter
Data by Single Criteria |
Topic 2F: Keep
Groups Together |
|
|
|
|
Lesson 3:
Grouping Report Data |
Lesson 3: Adding
Subreports |
|
Topic 3A: Insert
a Group |
Topic 3A: Insert
a Subreport |
|
Topic 3B: Add
Summaries |
Topic 3B: Link a
Subreport to Data in a Primary Report |
|
Topic 3C: Format
Summary Information |
Topic 3C: Edit a
Subreport |
|
Topic 3D: Change
Group Options |
Topic 3D: Format
a Subreport Using the Format Editor |
|
Topic 3E: Add an
Additional Group |
Topic 3E: Share
Formulas Between Main and Subreports |
|
Topic 3F: Filter
by Group |
Topic 3F: Create
an On-demand Subreport |
|
Topic 3G: Create
a Top N Sort Group |
|
|
|
Lesson 4:
Creating Drill-downs |
|
Lesson 4:
Building Formulas |
Topic 4A: Create
a Drill-down |
|
Topic 4A: Write
a Formula |
Topic 4B: Create
Separate Headings for Drill-down Data |
|
Topic 4B: Edit a
Formula |
|
|
Topic 4C: Group
by Formula |
Lesson 5:
Enhancing Report Processing Using SQL |
|
Topic 4D: Delete
a Formula |
Topic 5A: Create
a Report Using SQL Queries |
|
Topic 4E: Build
a Filter by Multiple Criteria |
Topic 5B:
Summarize Report Data Using SQL Aggregate Functions |
|
Topic 4F: Modify
a Filter with Multiple Criteria to Create an OR Condition
|
Topic 5C: Create
Joins Using SQL |
|
Topic 4G: Create
a Parameter Field |
Topic 5D: Create
Subqueries |
|
Topic 4H: Write
a Formula that Incorporates Null Fields |
Topic 5E: Create
an SQL Expression Field to Promote Server-side Processing |
|
|
|
|
Lesson 5:
Formatting Reports |
Lesson 6:
Charting Data |
|
Topic 5A: Remove
White Space |
Topic 6A: Create
a Bar Chart |
|
Topic 5B: Insert
Page Header/Footer Data |
Topic 6B: Modify
a Chart |
|
Topic 5C: Add
Borders and Lines |
Topic 6C: Create
a Top N Chart |
|
Topic 5D: Change
the Background Color |
Topic 6D: Format
a Chart |
|
Topic 5E: Change
the Margins |
Topic 6E: Create
a Chart Template |
|
|
|
|
Lesson 6:
Enhancing Reports |
Lesson 7:
Reporting on Excel Data |
|
Topic 6A: Create
a Section to Contain a Watermark |
Topic 7A: Create
a Report Based on Excel Data |
|
Topic 6B: Insert
Objects Using Object Linking and Embedding |
Topic 7B: Modify
a Report Generated from Excel Data |
|
Topic 6C: Modify
Format Based on Data Value |
Topic 7C: Update
Data in a Report Based on Excel Data |
|
Topic 6D:
Conditionally Suppress Data |
|
|
Topic 6E: Insert
Hyperlinks |
Supplemental
Lesson |
|
Topic 6F: Hide
Blank Report Sections |
Topic 1A:
Insert a Map |
|
|
|
|
Lesson 7:
Creating and Modifying Pie Charts |
|
|
Topic 7A: Create
a Pie Chart with a Drill-down |
|
|
Topic 7B: Modify
Chart Text |
|
|
Topic 7C: Format
a Chart |
|
|
Topic 7D:
Present a Chart by Group |
|
|
|
|
|
Lesson 8:
Distributing Data |
|
|
Topic 8A: Export
to PDF |
|
|
Topic 8B: Export
to Excel |
|
|
Topic 8C: Export
to an Access Database |
|
|
Topic 8D: Create
a Report Definition |
|
|
Topic 8E: Create
Mailing Labels |
|
