Course Outline

• 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
• Displaying Specific Report Data
  • Find Data
  • Sort Data
  • Filter Data by a Single Criterion
• 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
• 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
• Formatting Reports
  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders, Boxes, and Lines
  • Change Field Background Color
  • Change the Margins
• 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
• Creating Pie Charts
  • Create a Pie Chart with a Drill-Down
  • Modify Chart Text
  • Format a Chart
  • Present a Chart by Group
• 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