Building a query for financial aid purposes requires a knowledge of how the data flows from the ISIR to the mailing the award letter. In this presentation, I will cover which tables are used to store the data, how to group it, track it, and create edit queries that help maintain the quality of the processes. This will include the different options of joining tables, using expression to change/create data elements for reporting or edits, and how to retrieve data that can be Excel Pivot friendly.
The Higher Education User Group (HEUG) is a 501(c)(3) nonprofit dedicated to helping member institutions effectively manage administrative technologies to improve the student and user experience. We support executives, managers, and staff who select, deploy, integrate, and manage multiple systems by providing education, professional resources, and opportunities to connect with peers. As the digital landscape continues to evolve, HEUG adapts to meet the changing needs of its members while remaining committed to its core mission of connection, education, and advocacy.
Higher Education User GroupMesa, AZ 85212 United States
support@heug.org
M-F 8 AM to 5 PM MST
Join HEUG
Community Council
Interest Areas
Resources
Alliance Conference
Global Meetings
Online Webinars
Code of Conduct
Privacy Policy
Terms of Service
Copyright 2026 Higher Education User Group, Inc.
Copyright © 2026 Higher Education User Group, Inc.