Course Outline

Microsoft Access 2007 Reports & Forms
When you use Access, do you enter data directly into tables? Time to transform the way you work with Access. Create forms to efficiently – and safely – enter data. Customize reports and forms through formatting techniques; learn to create report sections and groups, and insert graphics, data, and expressions. Explore the power of check boxes, subforms and tab forms to gather data in a way that meets your objectives. (2 days)

Basic Report/Form Skills

  • What is a Report/Form?
  • Switching Views
  • Identifying Sections and Controls
  • Report Design Tools
  • Selecting Controls/Sections
  • Changing Selection Behavior
  • Changing Font/Alignment
  • Sizing a Control
  • Sizing a Section

Basic Editing Skills

  • Deleting a Control
  • Coping a Control
  • Moving a Control
  • Aligning Controls
  • Spacing Controls
  • Creating a Report Using a Wizard

Creating a Custom Report

  • Starting a Blank Report
  • Setting Page Setup Options
  • Displaying Properties
  • Setting Custom Report Properties
  • Setting Label Control Properties
  • Setting Text Box Control Properties
  • Adding Headers and Footers in a Report
  • Creating a Label Control
  • Placing Fields
  • Moving Labels to Page Header

Enhancing the Report

  • Creating a Report Template
  • Adding a Page Number
  • Adding and Formatting a Date Field
  • Adding a Line/Rectangle Control
  • Adding Unbound Objects
  • Creating a Multi-Column Report

Sorting and Grouping

  • Sorting Data
  • Creating Group Header/Footer Sections
  • Hiding Duplicates
  • Adding Totals in a Group Header or Footer
  • Changing Group Intervals
  • Keeping Groups Together
  • Calculating Percentages Using Expressions
  • Rearranging Group Order
  • Removing Sorting or Grouping

Report and Section Properties

  • Report Properties Summary
  • Changing Source for Records in Report
  • Suppressing Page Header/Footer
  • Section Properties Summary
  • Adding Page Breaks between Sections
  • Keeping Data Together

Text Box Properties in a Report

  • Changing the Control Source of a Text Box
  • Hiding Duplicates
  • Changing Format and Decimal Places
  • Creating a Running Sum
  • Sizing Sections/Text Fields Automatically

Creating a Custom Form

  • Starting a Blank Form
  • Setting Page Setup Options
  • Displaying Properties
  • Setting Custom Form Properties
  • Setting Label Control Properties
  • Setting Text Box Control Properties
  • Adding Headers and Footers in a Form
  • Creating a Label Control
  • Placing Fields
  • Setting Tab Order

Enhancing the Form

  • Creating A Form Template
  • Adding a Line/Rectangle Control
  • Adding Unbound Objects
  • Adding a Check Box Control
  • Adding a Combo Box Control
  • Changing a Control Type

Form and Section Properties

  • Form Properties Summary
  • Changing the Source for Records in a Form
  • Preventing Switching Between Views
  • Changing Editing Capabilities of a Form
  • Creating Additional Viewing Space
  • Record Dividers
  • Section Properties Summary

Text Box Properties in a Form

  • Text Box Properties Summary
  • Changing the Control Name
  • Changing the Control Source
  • Properties Set by Tables
  • Adding ControlTip Text
  • Enabled and Locked
  • Tab Stop and Auto Tabbing
  • Adding Scroll Bars

Other Forms

  • Creating a Continuous Form
  • Creating a Form for a Subform Control
  • Creating a Subform Control on Main Form
  • Creating a Multi-Source Form
  • Creating a Two Part Form
Prerequisites:  Access Level 2 or equivalent experience. Access Level 3 is recommended.

Revised 8/16/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600