Irvine Training Company                               www.IrvineTrainingCo.com
Access 125

and Create Queries, Forms, and Reports

1/2 day


This is the second in a series of half-day MS Access classes.
The required pre-requisite for this class is Access 115


click here to return
Topics may include:
Work With Multiple Tables Simultaneously by Creating a Query
  The Select Query and its Design Buttons
  Modify an Existing Select Query
  Use the Wizard to Create a New Select Query
  The Comparison and Conditional Operators
  Add Selection Criteria to a Query
  Delete Selection Criteria from a Query
  The Order of Operation in Access Expressions
  Use the Expression Builder to Add a Calculated Field to a Query
  Format the Fields in a Query
  Add a Total Row and Perform a Calculation on a Record Grouping

Design Custom Forms to View and Enter Data into Multiple Tables
  Form Design Guidelines
  Use AutoForms to Create a Custom Form
  Use the Form Wizard to Create a Custom Form
  Modify a Form’s Design
  Use the Sizing Handle to Size a Form Control
  Use Format/Size to Size a Form Control
  Align, Space and Move Form Controls

Produce Reports from Multiple Tables
  Use AutoReport to Create a Custom Report
  Use the Report Wizard to Create a Custom Report
  Examine a Report in Design View
  The Report Toolbox
  Add a Calculated Field to a Report
  Modify the Format Properties of a Control
  Use AutoFormat to Change the Report Style
  Adjust the Width of a Report to Print Properly

End


This is the second in a series of half-day MS Access classes.

The required pre-requisite for this class is Access 115
Computer training in Southern California