Course Outline

Access Reports and Forms
Focus on essential skills for creating reports and forms based on single and multiple table queries with sorting and parameters. Start with basic editing skills to build custom reports, set properties, place fields. Create templates, learn formatting. Sort and group data; insert expressions & subtotals; add totals in group header/footer. Work with form and section properties, text box properties. Add check boxes and combo boxes. Create a continuous form, subform control, multi-source form, two-part form. 12 hours
Basic Report/Form Skills 
  • What is a report/form? 
  • Identifying sections and controls 
  • The toolbox/toolbar 
  • Selecting controls/sections 
  • Changing font/alignment 
  • Sizing a control /section 

Basic Editing Skills 

  • Manipulating controls 
  • Creating a report using a wizard 

Creating a Custom Report 

  • Setting report and control properties 
  • Setting page setup options 
  • Adding headers and footers in a report 
  • Moving labels to page header 

Enhancing the Report 

  • Creating a report template 
  • Adding a page number 
  • Adding and formatting a date field 
  • Adding unbound objects 
  • Creating a multi-column report 

Sorting and Grouping 

  • Manipulating groups and sorts 
  • Hiding duplicates 
  • Adding totals in a group header or footer 
  • Keeping groups together 
  • Calculating percentages using expressions 

Report and Section Properties 

  • Report/section properties summary 
  • Changing source for records in report 
  • Suppressing page header/footer 
  • Adding page breaks between sections 
  • Keeping data together 

 

Text Box Properties in a Report 

  • Changing the control source of a text box 
  • Changing format and decimal places 
  • Sizing sections/text fields automatically 
  • Creating a running sum 

Creating a Custom Form 

  • Setting page setup options/tab order 
  • Adding headers and footers in a form 

Enhancing the Form 

  • Creating a form template 
  • Adding check box, combo box, etc. 
  • Changing a control type 

Form and Section Properties 

  • Changing the source for records in a form 
  • Preventing switching between views 
  • Changing editing capabilities of a form 
  • Creating additional viewing space 
  • Record dividers 

Text Box Properties in a Form 

  • Changing the control name/source 
  • Properties set by tables 
  • Adding control/tip 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 1 required (Level 2 recommended) or equivalent experience.
Revised 7/7/08
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600