I’m buliding a database at work, and was curious as to what folks think of my design. It’s my first time using access.
Basically, we surveyed employees by having them sort a stack of index cards into six categories of their own creation. We’d like to be able to querry the info by category, by department of the respondees, understanding that there may be multiple people from the same department, and any given item will appear in numerous categories.
I’ve got a few tables:
Department: A key and a list of departments
Testers: A key, First Name, Last Name, and a Number corresponding to the Department
Catagories: A key, the name of the Category, and a Number corresponding to the individual Tester who came up with the category
Objects: A key, the name of the Object (what was written on the index cards), and then n number of Category fields, corresponding to the number of people we have do the sorting. This somehow seems less than efficient, but I’m not thinking of a better way to do it.