Unanswered: Need help designing VERY simple database...
I am reasonably familiar with Access but for some reason I am getting all confused when it comes to creating a simple relational database.
Basically, it is a simple database for a small school. 100 students separated into 5 groups. Some groups are doing Level 1 and some are doing Level 2. There are certain subjects they study at Level 1 and certain subjects they study at Level 2. So that much was easy to design. It can show what students are on what level, in what group etc.
However, where I seem to be confusing myself is when it comes to the actual subjects they are doing. I want to be able to show what subject a particular student is doing and what ones they have done so far and yet to do. If that makes sense?
Once the structure is in place, I can enter all the necessary data and then I want to create a launch form for people to access and view/edit info.
This is the structure I have so far. (my module I mean subject)
I would be grateful for any help on this as it is rather urgent I have it finished.