I am setting up a student grade reporting database. There will be a Student Master Table (SMT) which will contain personal information about each student, including a unique Student-ID. There will be a Course Master Table which will contain information about each course, including the name and Course-ID. The students, of course, will change each semester, so adding or deleting student records from the SMT is straight forward. The courses will also change periodically, so here's my question:
What table layout would you suggest in order to record the latest grade for each student. This grade update will be done with a Form. I only need the latest grade for each course for each student for this assignment. I'm thinking that there would be a record for each student in this table (call it the Student Grades Table, or SGT), and the fields in the SGT would represent the courses that are available. In this assignment, the same courses would be available for all students, although all students would not take the same courses. Since the courses change over time, and course names can be lengthy, how do I set up field names in order to avoid having to change the field names in the table each time courses are added or deleted?
Or, would you take a different approach to the database tables?
Thanks for your suggestions.
What table layout would you suggest in order to record the latest grade for each student. This grade update will be done with a Form. I only need the latest grade for each course for each student for this assignment. I'm thinking that there would be a record for each student in this table (call it the Student Grades Table, or SGT), and the fields in the SGT would represent the courses that are available. In this assignment, the same courses would be available for all students, although all students would not take the same courses. Since the courses change over time, and course names can be lengthy, how do I set up field names in order to avoid having to change the field names in the table each time courses are added or deleted?
Or, would you take a different approach to the database tables?
Thanks for your suggestions.