Orange Coast Database Associates
P.O. Box 6142
Laguna Niguel, CA 92607

Previous Page

949-489-1472 (Office)
800-355-9855 (Toll free)
http://www.ocdatabases.com

Accelerated training for working professionals

Orange Coast Database Associates, Inc.
Course Catalog

Item IDCourse Title and DescriptionLength
AIA101Accelerated Introduction to Access9.0 hrs
 Accelerated Introduction to Microsoft Access course for experienced Microsoft Office users. Corresponds roughly to material required for MOS certification. Covers tables, external data, queries, forms, reports, action queries, macros and navigation. Students will create a working database application during this intensive, hands-on course. This database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access assumed although students should be proficent with standard Microsoft Office.

 
Session 1Tables and Queries 
 
  • Creating an MS Access database
  • Designing tables
  • Exporting tables to Excel and text files
  • Importing files
  • Creating Permanent Links between Tables
  • Creating simple and multi-table queries
  • Calculated fields and concatenation
  • Summary and parameter queries
  • Using the expression builder

 
Session 2Reports and Forms 
 
  • Creating reports
  • Formatting your report.
  • Adding graphics.
  • Subreports and one-to-many reports
  • Creating forms
  • Formatting your form
  • Adding subforms to a main form
  • Subtotals
  • Using the builders and wizards.

 
Session 3Automating Tasks 
 
  • Action queries.
  • Macros
  • Using control wizards.
  • Switchboards & Navigation Forms