Getting the information you need from your database is an important measure of its power - and also a measure of your own mastery of the program.
In this one-day course you will increase the scope and power of your Access queries, using advanced selection criteria, wildcards, queries involving calculations, the Query Wizard, cross tabulations, an introduction to SQL, sub-queries, nested sub-queries and more. This course offers great value to the Access database user.
Date: November 12, 2014
Location: 1 Martine Avenue, White Plains, NY
Course Number: 90766
Date: Please call for dates
Location: 551 Fifth Ave., NYC
Access Power Queries is a one day course designed for individuals who know the fundamentals of Access, but would like to enhance their knowledge of queries. This course concentrates on using the power of the database program to extract information. Students will learn how to design advanced queries using functions and set criteria to isolate data. Action queries, joins, and the find unmatched and find duplicates query designs round out the content.