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
AIN100AIntroduction to MS Access I6.0 hrs
 1 day introductory Microsoft Access course covering databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using a modern case-based approach, students will create a small database application during this course. No prior knowledge of Access is assumed. (Same as AIN100 Introduction to Microsoft Access day 1; 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 
 
  • Filters
  • Creating simple and multi-table queries
  • Calculated fields and concatenation
  • Summary queries
  • Using the expression builder

 
Session 3Basic Reports & Forms 
 
  • Creating a report
  • Creating a form
  • Finding and filtering data
  • Adding a switchboard