Are my tables created correctly (normalized) so far?
I have attached a database that I have created. Before I get much further - I wanted to make sure that I am building my tables correctly
I have also attached a PDF file of what the final form I am trying to create is supposed to look like. Each instructor will enter in the student information, their attendance, as well as the grades. I need to have the attendance and grades total for them automatically.
Attendance will be the total of the "A"s (absent) and the total number will be in the "Att" field. Grades will be the average of Shop, Math, BP for each class (Total will be in "Train Avg" field)
Before I move onto the form - I want to make sure that my tables are set up properly now.
thank you
sampledb2.accdb
Students.pdf
I have also attached a PDF file of what the final form I am trying to create is supposed to look like. Each instructor will enter in the student information, their attendance, as well as the grades. I need to have the attendance and grades total for them automatically.
Attendance will be the total of the "A"s (absent) and the total number will be in the "Att" field. Grades will be the average of Shop, Math, BP for each class (Total will be in "Train Avg" field)
Before I move onto the form - I want to make sure that my tables are set up properly now.
thank you
sampledb2.accdb
Students.pdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER