Want to create grade card report in ms access for school. Each student has to take 9 subject, each subject has 6 exams say fa1, fa2, sa1, fa3, fa4 and sa2. Each of these exams are having marks 15,15 and 20
Want to create grade card report in ms access for school. Each student has to take 9 subject, each subject has 6 exams say fa1, fa2, sa1, fa3, fa4 and sa2. Each of these exams are having marks 15,15 and 20
You need some of these tables:
fields with * are keyed.
tStudents table
StudentID*
FirstN
LastN
Addr
City
etc...
tTeachers table
TeacherID*
FirstN
LastN
etc
tClasses table. (algebra rm101)
ClassID*
ClassName
Subject
TeacherID
etc...
tClassRoster table (all students in 1 class)
ClassID*
StudentID*
Status (dropped, removed,active)
Memo
tAssignments table (all work given to students in 1 class)
AssignID (autonum)
ClassID*
AssignName*
AssignDate
DueDate
TotalPoints
Memo
tStudentWork table. (the assigment that a student worked on, graded)
StudenWorkID (autonum)
StudentID*
AssignID*
Points
Grade
Memo
tClassDates table (all dates a class meets. used for attendance)
ClassDateID (autonum)
ClassID*
ClassDate*
Status (meet, cancelled, holiday)
Memo
tAttend table. (student attend that class date)
ClassDateID*
StudentID*
Status (present, absend, excused,sick)
Memo
Hi
Can you upload a zipped copy of your database?
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description