Classroom Manager Database Customized Report

[Guest]

I need to create a report that gives all of the assignments and grades for a
single student in a single class. The Results by Student report that came in
the template will give the results for all of the students, which doesn't
really help me. I'm new to Access, and I can't figure out how to do this, if
it can be done.

 

[Will Sellers]

assumption:

your tables are students student assignments and student classes

write a query to pull assignment information that is linked to "student
Class" .

The relationship is a student has many classes and each class for that
student has many assignments.
Therefore the keys would be studentid ======>student id in Classes

classeid

Studentid ======> Studentid

Classeid in student assignments

The Studentquery would look something like this:

student studentid class class_assignment grade

You can put in selection criteria for student and class

Then you can create a report that uses the studentquery as its source.