• April 12, 2012
  
• May 14, 2012
  
• June 15, 2012
• July 11, 2012
  

COURSE DESCRIPTION

The Access Intermediate course will introduce more advanced skills
used in database management, as well as reviewing basic skills.  The
learner will gain a thorough understanding of queries, along with
guidelines for creating and modifying forms, charts, and reports.

Pre-requisite: Access 2007/2010 Basics or equivalent experience

Full Day Class Only $175.00 (Unless otherwise specified full-day
classes are weekdays from 9am to 4pm)

COURSE HIGHLIGHTS

• Database Normalization
  
• Relating Tables
  
• Implementing Referential Integrity
  
• Lookup Fields
  
• Modifying Lookup Fields
  
• Subdatasheets
  
• Joining Tables in Queries
  
• Calculated Fields
  
• Summarizing and Grouping Values
  
• Adding Unbound Controls
  
• Adding Graphics
  
• Adding Calculated Values
  
• Adding Combo Boxes
  
• Advanced Form Types
  
• Creating Customized Headers and Footers
  
• Printing Database Objects
  
• Creating Labels
  
• Charts in Forms
  
• Charts in Reports
  
• PivotTables
  
• Modifying PivotTables
  
• PivotCharts
  
• PivotTable Forms