Friday, September 10, 2010
Access 2007 Level 2 Minimize
Class Time 6 hours
Prerequisite:  Access 2007 Level 1 or equivalent experience.

Topics covered in this class include:
 
CONTROLLING DATA ENTRY 
  • Restrict Data Entry Using Field Properties 
  • Establish a Pattern for Entering Field Values 
  • Create a List of Values for a Field
JOINING TABLES
  • Create Query Joins 
  • Join Unrelated Tables
  • Relate Data within a Table 
CREATING FLEXIBLE QUERIES
  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries 
IMPROVING FORMS
  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data  Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform
CUSTOMIZING REPORTS 
  • Organize Report Information
  • Format the Report 
  • Set Report Control Properties 
  • Control Report Pagination 
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report 
SHARING DATA ACROSS APPLICATIONS 
  • Import Data into Access 
  • Export Access Data
  • Analyze Access Data in Excel
  • Export Access Data to a Text File
  • Merge Access Data with a Word Document 

 

    

Copyright 2009 by The Continuous Improvement Center