Hi,
I am working on an Access database for work and basically it needs to be students, the classes they are taking, their grades.. etc. I have made 2 separate databases with the same information in 2 different ways and I have come to the point where I don't know what else to do.. not sure how to move on from here. One database has 4 tables.. Student Info, Instructors, classes, and testing.
classes is the main table and has the fields: class ID/class name/level/instructor ID/term/location/days×
The class ID is the primary key
When i go to the testing table, I realized that I can only put in 1 class ID in the class ID field.. but each student takes more than 1 class..
how would I proceed?
The second database has 4 tables (class info, personal information,instructors, and grades/results)
I am trying to incorporate the information from 3 semesters into the database, and made a form to see all of the information in one place. but I noticed that when I enter a second semesters information, the form only shows the students who were listed in BOTH semesters.
I dont know if I made any sense... is there anyone out there who can help me? I would really like to finish this database.
thanks!