multiple table one form

[mayi]

hi. I'm new at access..and i need help. i was asked to do 4 tables. First table is the student information (student id, first name, last name,middle name, course, birthdate) 2nd table is the Prelim grade ( quizzes, attendance, hands on, exam, project) same for 3rd table midterm and 4th table finals. For our form, we were asked to show the computed prelim grade, mid term grade, and final grade. and that's my problem .... i dont know what expression or formula to use... how do i link it? here are the instructions and attached is what i did so far... can some one pls. help me?


FINAL DATABASE STRUCTURE


TABLE
1. STUDENT INFO 2. STUDENT GRADE(PRE/MED/FIN)
-Student Number QUIZZES 20 %
-First Name PROJECT 10 %
-Last Name ATTENDANCE 20%
-Course EXAM 25%
-Birth Date HANDS-ON 25%
-Remarks

[June7]

You were TOLD to put the grades in 3 tables? I would put them in one. Have another field for GradeType (Pre, Med, Final).

The StudentInfo table would have a 1 to many relationship with the Grades table.

Then for data entry use form/subform arrangement http://office.microsoft.com/en-us/ac...010098674.aspx

Then build a report with a RecordSource that is a join of the two tables. Use report grouping & sorting with aggregate calcs in group header/footer.

This is basic Access functionality and Access Help has more guidelines on building these objects.

Good Luck.

[mayi]

Thank you June7. Trying it now.. will let you know in a few.