|
Hi,
I am a beginner with ACCESS (and databases in general): I know the basic functions, but I am unsure how to contruct a database with the following information:
1) I have around 100 students who need to choose between around 30 courses for 1 og 2 semesters.
2) About half of them are bachelor student, half are master students. Both groups can join all the courses.
3) For a course to be realised a minimum of 6 students have to join.
4) The students have a 1., 2., 3. and 4. priority.
5) All in all the database needs to contain the following information: a) First name, b) last name, c) main subject, d) bachelor or master, e) all the possible courses, f) 1. priority, g) 2. priority, h) 3. priority, i) 4. priority
In the first instance I just have to register the above information. Someone else has to find out which students join which courses. If, on the other hand, I would be able to contruct the database in a way that would make that persons work much easier it would give me a lot of credit.
If one could make a report that shows who has 1., 2., 3. and 4. priority for any given course at 1. or 2. semester it would be even better.
If the database would be used to "parcel out" the students on the various courses and giving as many as possible their first priority it would be great.
Any suggestions for a particular structure to use?
The best. Any help will be greatly appreciated. Anders.
|
