Windows 7 64bit 
Access 2010 64bit
I am going to record student’s scores in a table like the following :
Student names are looked up from student_list table and subjects from subject_list table.
students_cores table:
ID, studentname, subject, score
1, john, mathematics, 80
2, john, physics, 87
3, john, history, 75
4, john, biology, 90
5, john, chemistry, 73
6, john, mathematics, 84
7, john, literature, 69
8, Jack, mathematics, 79
9, Jack, physics, 58
10, Jack, history, 80
11, Jack, biology, 93
12, Jack, chemistry, 79
13, Jack, mathematics, 71
14, Jack, literature, 76
.
.
.
.
Is it a good idea to have the above table? Is there a wiser way to record each student record for a given subject?
thank you
Reply With Quote
