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.d2associates.com
Accelerated training for working professionals

Microsoft Access and Relational Database Training
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 MOUS proficient level plus some additional material. Covers tables, external data, queries, forms, reports and macros. 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. Available in 2003 and 2007 versions.

 
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