Hi all,

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)

Click image for larger version. 

Name:	db1.jpg 
Views:	7 
Size:	45.3 KB 
ID:	16135

I would be grateful for any help on this as it is rather urgent I have it finished.