Hello,
I've spent the last 2 days going over the suggested beginner YouTube videos regarding DB theory that a thread here posted and some using MS Access.
Our department offers different faculty development workshops 4 times a year. We track attendance and create a report each session for the administration. We have been using Excel but it is not meeting our needs.
I need to be able run a report that shows X professor attended Y events and X number of faculty in this department attended Y number of events, etc. I have imported data on the faculty and departments from my Excel spreadsheet to create tables. The Employee table has EmployeeID, first, last, DeptID. The Department table has DeptID, Department Name, Title.
My question is about the events that change 4 times a year and have multiple sessions of each workshop.
Do I create a table for each separate workshop? What attributes would I have- just title and date? I'm confused here about how I connect the faculty member, department and workshops. I'm sure it's easy, but I just don't have that lens to see it clearly.
I use EventBrite for registration and can export a Excel spreadsheet to use for attendance.
Thank you in advance for any help,
Debbie