This 3-hour workshop will introduce the query object. Topics covered will include working 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 explore other kinds of queries such as a totals query, parameter query, action queries, find duplicates query, unmatched records query and basic SQL query.
Prerequisite: Completion of Access 2016 Getting Started and Tables or equivalent knowledge
Hours: 3 hours
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.