Tracking student grades db

E

elph

Joined
Sep 30, 2005
Messages
1
Reaction score
0
I am trying to create a db to track grades for three classes. I created 4 tables:

Classes - Fields: ClassID (grades -10, 11, 12), ClassDescription
Students - Fields: StudentID (autonumber), ClassID, FName, LName
Assignments - Fields: AssignmentID (autonumber), AssignmentName, Points, Date...etc..
Grades - Fields: GradesID (autonumber), PointsEarned, LetterGrade, StudentID, AssignmentID

Tbl Relationships:

Classes - Students (ClassID)
Students - Grades (StudentID)
Assignments - Classes (ClassID)
Assignments - Grades (AssignmentID)

I have an Assignement form that is linked to the Assignments tbl and allows the user to enter the ClassID and name of the assignment and the other fields. I am trying to create another form that is linked to the Assignments form. On this form I want the names of the students from the ClassID selected on the Assignments form to appear. I then want to enter the students grade that will link to the GradesID.

Are my tables set up properly? I'm new to this so I'm not quite if I'm using the right approach.
Any advice would be greatly appreciated!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting up tables for grades 17
Type mis match in expression on a form 2
append multiselect to table 8
Question on Tables & Relationships 5
Using a subform to display and add info into table 19
How do I create this form? 4
Cannot See a Child Table Field 6
Form Is Read Only 2

Top