Working with Queries in Microsoft Access
Narrow down a data set to fit a particular need using queries in Microsoft Access. This class will expand on your knowledge from the Introduction to Microsoft Access class.
During this three-hour class, you will learn to create and work with queries based on the access tables that are in the database. We will also explore many different types of queries and the relationships needed to make the queries work properly. This class is offered at least once a quarter.
Learning Outcomes
- Create multiple types of querie: Simple Query, Parameter Query and Cross Tab Query
- Understand relationships and join properties for tables and queries
- Add calculated fields to a query to summarize fields or determine the difference between fields
Intended Audience
UB faculty and staff
Prerequisites
Familiarity with Microsoft Access and experience with creating, editing, formatting, and saving basic databases or, attended the Introduction to Access class
Fee
Free
Class Schedule and Registration
Log in to UB EDGE to view class dates and register. (Don't have a UB EDGE account? Search for dates on the UB Calendar and email training@buffalo.edu or call 716-645-4459 to register.)
May Also Interest You
Instructor
Rosanne Steinmetz
Owner and Instructor
Quality PC Training
Email: training@buffalo.edu
Contact for Questions
Kerry Lynch
Program Coordinator
Organizational Development and Training
Phone: 716-645-4459
Email: training@buffalo.edu
The University at Buffalo is committed to providing reasonable accommodations to individuals with any disabilities. If you require accommodations to participate in this session, please contact Organizational Development & Training (OD&T) at (716) 645-4459 or training@buffalo.edu prior to attending the class. Please allow ample time for OD&T to work with the Office of Accessibility Resources to arrange accommodations.