This event has completed.

7/28/2022
1:30 PM - 3:00 PM EST

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