I maintain an Access Database for my team at work. My team is supplying the table data in a new format that I am supposed to upload into the database. I have attached an Excel file to give you an example. The new format is on the first sheet entitled "New Data Format". The old data format they supplied me and what I uploaded directly into the database is on the "Old Data Format" sheet.
How would I go about incorporating the new data format into the table design? Note: This is a blank table with no existing data in it, so I can modify the design.
I do queries off this data. For example, a report that shows which people are assigned "Role 2" or which courses are people taking who have "Role 3" (A separate table maps the roles to courses).