Go beyond basic select queries, getting to the information you really need by becoming more adept at specifying selection criteria, performing calculations, parsing fields into multiple fields, and setting parameters. Create complex summaries of data by nesting queries and adjusting join properties for select and totals queries. Learn to specify criteria on the value field in a crosstab query, use the column headings properly, and use action queries to clean up data and perform archiving and updates. Prerequisite: Intermediate Access.
Weekly - Tue, Thu
Please read: This class uses version 2016. UNM Tuition Remission eligible under Professional Development.
Registration Closes On
August 29, 2017 @ 11:59 PM