Results 1 to 4 of 4
  1. #1
    dao53228 is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    2

    Beginner Design Question: Tracking Attendance for Faculty Development Workshops

    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

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    All events would go in one table.
    Because one employee can go to many events AND one event can have many employees, you have a many-to-many relationship.
    Consider this design
    Click image for larger version. 

Name:	Presentation1.png 
Views:	23 
Size:	58.2 KB 
ID:	42075
    Note: This design is just a starting point.

  3. #3
    dao53228 is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Posts
    2
    Thank you very much for taking the time to reply. This is exactly what I needed!

    Debbie

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Happy to help....

    And welcome to the forum.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-22-2019, 06:13 PM
  2. Event Attendance Tracking
    By accessboy96 in forum Access
    Replies: 2
    Last Post: 06-25-2017, 01:28 PM
  3. Please help with design for Faculty/Commencement event
    By Sleaf in forum Database Design
    Replies: 1
    Last Post: 03-29-2017, 08:47 PM
  4. Asset tracking database design question
    By ittechguy in forum Database Design
    Replies: 9
    Last Post: 11-09-2015, 04:41 PM
  5. Replies: 19
    Last Post: 03-23-2015, 03:09 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums