Access table and relationnship problem

[alobi]

I will appreciate if somebody could look at my table setup and tell me what rearranging I need to do, help me with putting together the relationship. Thanks


courses
CourseID PK
About 20 courses
Table Grades
CourseID Pk
Assessment
Exams
Total=[Assessment + Exams]
Students
StudentId PK
LastName
FullName
Address
I will appreciate if somebody could look at my table setup and tell me what rearranging I need to do, help me with putting together the relationship. Thanks
courses
CourseID PK
About 20 courses
Table Grades
CourseID Pk
Assessment
Exams
Total=[Assessment + Exams]
Students
StudentId PK
LastName
FullName
Address

[June7]

Student grades db is fairly common topic. Trying searching forum on those key words. Here is one https://www.accessforums.net/showthread.php?t=53065

Also, review http://databaseanswers.org/data_mode...xams/index.htm