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 (All Modalities)

Item IDCourse Title and DescriptionPricePerLength
AIN102Microsoft Access Focus on Queries165.00Student6.0 hrs
 Learn effective MS Access query design in this unique, hands-on course. Covers select, maketable, append, update, delete and union queries. Includes single and multi-table queries, functions, summary queries, inner joins, outer joins, and subqueries. Ideal course for those seeking a deeper knowledge of Access queries than is taught in traditional Access classes.

 
Session 1Basic MS Access Data Retrieval 
 
  • Relational database foundations
  • Basic data retrieval operations
  • Select queries
  • Filters, Where clause
  • Special Operators, Searching
  • Sorting
  • Calculated fields, Concatenation
  • Parameter Queries

 
Session 2Advanced MS Access Queries 
 
  • String Manipulation
  • Date Functions, Etc.
  • SQL Aggregate functions (SUM, AVG, etc.)
  • Group by
  • Having
  • Inner join, outer joins, self join
  • Subqueries
  • Unions
  • Action queries (Maketable, Append, Update, Delete, Maketable)