North East Association for Institutional Research (NEAIR), Inc. - Event Information


Event Name:Automate Data Cleaning and Updating Using Microsoft Access
Event Type(s):Workshop Webinars
Description:Are you looking for an automated way to clean and update data? If yes, Microsoft Access could be the solution. Microsoft Access is a powerful tool to review, clean, update, and manipulate data without needing to write code. When working with data that needs cleaned and analyzed regularly, spending time now creating the processes in Access has the potential to save hours of work later. By the end of the workshop, participants will have the knowledge to import data to Access, review a field of data for inconsistencies, update the data using append and update action queries, and create a form with buttons to run the queries and document the processes. Both an Access and Excel file with dummy data will be available to participants to create the tables, queries, and form during the session, if desired. A general understanding of tables, table relationships, and querying is suggested to get the most out of the workshop. Software Requirements: Microsoft Access, preferably 2019
Presenter: Christy King, PA State GEAR UP, Shippensburg University/PA State System of Higher Education
Event Date:7/28/2022
Event Time:1:30 PM - 3:00 PM Eastern
Location:Virtual
Event Registration:
Outlook/vCalendar/Google:Click on the icon next to the date(s) to add to your calendar:
7/28/2022
Email Reminder:click here to setup an email reminder for this event


return to North East Association for Institutional Research (NEAIR), Inc.