2 Day Course

Performance-based objectives

• 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.

Prerequisites

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. Before taking this course, students should be familiar with the basic functions of Windows, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, students should have taken Microsoft Office Access 2003: Level 1 or have equivalent experience with basic database concepts.

Course content

Lesson 1: Creating a Report

• A: Set Default Report Settings
• B: Specify Fields for a New Report
• C: Preview a Report
• D: Modify Field Display
• E: Add a Report Title
• F: Position Fields
• G: Add Fields from Other Tables

Lesson 2: Displaying Specific Report Data

• A: Find Data
• B: Sort Data
• C: Filter Data by a Single Criterion

Lesson 3: Grouping Report Data

• A: Insert a Group
• B: Add Summaries
• C: Format Summary Information
• D: Change Group Options
• E: Add a Second-Level Grouping
• F: Filter Records by Group
• G: Create a Top N Sort Group

Lesson 4: Building Formulas

• A: Create a Formula
• B: Edit a Formula
• C: Combine Fields by Formula
• D: Delete a Formula
• E: Filter Data by Multiple Criteria
• F: Modify a Filter Using an OR Operator
• G: Create a Parameter Field
• H: Account for Null Fields in a Formula

Lesson 5: Formatting Reports

• A: Remove White Space
• B: Insert Page Header/Footer Data
• C: Add Borders, Boxes, and Lines
• D: Change Field Background Color
• E: Change the Margins

Lesson 6: Enhancing Reports

• A: Add a Watermark
• B: Insert Objects Using Object Linking and Embedding
• C: Modify Formatting Based on Data Value
• D: Suppress Report Sections
• E: Insert Hyperlinks
• F: Hide Blank Report Sections

Lesson 7: Creating Pie Charts

• A: Create a Pie Chart with a Drill-Down
• B: Modify Chart Text
• C: Format a Chart
• D: Present a Chart by Group

Lesson 8: Distributing Data

• A: Export to a PDF File
• B: Export to a Microsoft Excel File
• C: Export to an Access Database File
• D: Export a Report Definition
• E: Create Mailing Labels

For Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com