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

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

SQL200A: Access SQL & Query Design Training

Book List | Course Links

Tuition: $195.00 per student

Length: 1 day

Synopsis: Introductory Access SQL Programming course using MS Access. Also covers using the MS Access Query Designer. Students will gain a thorough introduction to designing and implementing MS Access queries using JET SQL in this unique course. Can also be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.

Formats: Small groups onsite at your facility or online. Single individuals may arrange a private online session.

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

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


Format this document for printing

Session 1Basic MS Access SQL Data Retrieval, Functions3.0 Hours
  • Relational database foundations
  • Basic data retrieval operations, DML
  • SQL Select statement
  • SQL Predicates, SQL Where clause (filters)
  • Operators
  • Sorting
  • Calculated fields, Concatenation
  • SQL Date Functions, Etc.
Session 2MS Access SQL Grouping, Data Manipulation3.0 Hours
  • String Manipulation
  • SQL Aggregate functions (SUM, AVG, etc.)
  • SQL Group by
  • Having
  • Inner join, outer join, self join
  • Single and multi-valued subqueries
  • Queries built from queries
  • Unions
  • Modifying data: Insert, Update, Delete, Select...Into
  • Parameter queries

Materials: Manual with PowerPoint slide and training certificate.


Location: Classes are normally taught on-site at your facilities or via online Remote Learning. 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 2022 D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel, CA 92607 949-408-1350
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