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.

On this page:

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

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.