This 2-hour in person class introduces the query object in Access. We will work with queries in the design view; creating a simple query by adding and removing fields and adding criterion. We will move on to creating multi-table queries; create calculated fields and set field properties; and briefly explore other kinds of queries such as a totals query, parameter query, and action queries.
Prerequisite: Completion of Access Getting Started and Access Tables or equivalent knowledge.
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.
Location: 329 Armory Building
Training labs are located at the Armory Building (505 E. Armory, Champaign, IL). There are MTD bus stops at every corner of the building (northwest, southwest, northeast, northwest). It is best to enter the building at the southwest corner (4th & Gregory -- across from Huff Hall). There is an elevator just inside the southwest entrance. Exit on the third floor and turn left down the hallway.
Parking
Unrestricted metered parking is available in Lot E3 and along Sixth Street, south of Armory Street. There are 5 designated accessible parking spaces in Lot E3 (corner of Gregory & 6th). Contact the Division of Campus Parking and Transportation at (217)333-3530 or visit Parking at Illinois for more information.
Add this class to your calendar:Browse to the WebStore Events Calendar, select your course, select the calendar symbol , select your calendar format, open the file, and save the item to your calendar.
Technology Services
1211 Digital Computer Lab 1304 W. Springfield Ave. Urbana, IL 61801
Email: webstore@illinois.edu
Office of the Chief Information Officer