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
AIN102Microsoft Access Focus on Queries6.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)