Orange Coast Database Associates Course Catalog

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.d2associates.com
Accelerated training for working professionals

Microsoft Access and Relational Database Training
Course Catalog

Item ID	Course Title and Description	Length
AIN102	Microsoft Access Queries	6.0 hrs
	Learn effective MS Access query design in this unique, hands-on course. Covers select, maketable, insert, 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 1	Basic 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 2	Advanced 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)