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
AIN100Introduction to Microsoft Access12.0 hrs
 2 day introductory course covering databases, tables, the datasheet, sorting and manipulating tables, import/export, queries, forms, reports and macros. Using a modern case-based approach, students will create a small database application during this course. No prior knowledge of Access is assumed. Available in Access 2003 and 2007.

 
Session 1Tables and Data 
 
  • Relational database foundations and design
  • Creating an MS Access database
  • Designing tables
  • Field and table validation
  • Manipulating and sorting the datasheet
  • Office Links
  • Creating Permanent Links between Tables

 
Session 2Filters, Queries, Reports & Forms 
 
  • Filters
  • Creating simple and multi-table queries
  • Using the expression builder
  • Calculated fields and concatenation
  • Summary queries
  • Using the report and form wizards
  • Creating a basic switchboard for your application

 
Session 3Reports and Forms in Depth 
 
  • Creating reports and subreports.
  • Formatting your report.
  • Adding calculations to your report
  • Adding graphics.
  • Creating forms and subforms.
  • Unbound forms.
  • Using the builders and wizards.

 
Session 4Automating Microsoft Access Tasks 
 
  • Exporting tables to Excel and text files
  • Importing and linking files
  • Advanced queries.
  • Macros
  • Using control wizards.
  • Finalizing your switchboard