Orange Coast Database Associates Database Training, Design and Programming Course Listing Page

Course Description

News and special offers from Orange Coast Database Associates


Related Courses

Group Training

Individual Training

Scheduled Classes

What's New!


Site Map

Free Catalogs

Special Offers

Request Information or Quote

Sales: 800-355-9855


About Us



Contact Us

AIN102: Microsoft Access Focus on Queries

Book List | Course Links

Tuition: $165.00 per student

Length: 1 day

Synopsis: 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.

Formats: Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.

Scheduling: Flexible to suit your requirements. Both onsite and online classes are custom scheduled.

Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote


Format this document for printing

Session 1Basic MS Access Data Retrieval3.0 Hours
  • 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 Queries3.0 Hours
  • 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)

Materials: Students will receive a notebook with a printout of all slides used in their class and a training certificate.


Location: Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.

Related Services

Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.

Copyright(2001-2016) D.H.D'Urso & Associates

Contact Information | FAQ's | Site Map | Back | Home | Top