Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

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

Session 1	Basic MS Access Data Retrieval	3.0 Hours
	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	3.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 via online Remote Learning. 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.