Been a long time since I have used Access (10 years or so) but I have been asked to create a database to track some information.
I work at a college, we have about 80 students spread over 8 groups. They complete qualifications each year, these qualifications are made up of different units (with unique ref numbers). The students can do the same 'qualification' but it must be made up of different units in subsequent years
Often our students will stay in our department for up to 5 years (sometimes changing groups, sometimes not), we need a way of recording who has done what unit, what year they did it and which group they were in when they did it
I tried to do it in Excel but got really confusing. The students do roughly 14 units per year.
When planning for the following year we need to be able to pull up say all of the students who have done a particular unit, and which group they are in.
Any of that make sense?
1 student will do many units, 1 unit could be done by many students.
Am a bit lost if anyone could offer any ideas?