Top bar

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

Course Description

News and special offers from Orange Coast Database Associates

Separator bar




Programming &

What's New!


Site Map

Free Catalogs

Special Offers

Separator bar

Current Category

Related Courses

Request information or a quote

Enroll in a public scheduled class

Sales: 800-355-9855


About Us


Contact Us

AIN102: Microsoft Access Focus on Queries

Book List | Course Links

Tuition: $245.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: Corporate groups (min. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may take a scheduled class or arrange a private class.

Scheduling: Flexible. Group and private training can be scheduled to suit your needs. See calendar for scheduled classes.

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 2017 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-489-1472
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties and beyond.

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