Access: Mastering Queries

ID : 80936   
« back to classes page
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.

Class Details

2 Sessions
Weekly - Tue, Thu

Location
CE South Building

Instructor
Rick Berg 

 

Notice

Please read:  This class uses version 2016. UNM Tuition Remission eligible under Professional Development.

Tuition: 

$239.00


Registration Closes On
Tuesday, August 29, 2017 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
8/29/2017 - 8/31/2017 Weekly - Tue, Thu 1:30 PM - 4:00 PM Albuquerque, CE South Building  Map, Room: Lab I Rick Berg