Problem: I need to know who is missing which scores for the whole grading period. These are uncompleted assignments and tests.
One solution: Create a table that show this information along with the student's name.
The query Make Table-Zeroes-6thTerm from LanguageArtsClasses database brings fields from several tables and queries together. The purpose of the query is to make a table showing the assignments and tests in the 6th grading period that have a final score of 0.
Select: Choose the fields to include from various tables/queries for the new table.
Add Criteria: 6 in the Grading Period column and 0 in the
I could have made this a parameter query by putting [Which grading period?] in the Criteria row for the Grading Period column. (This would actually have made more sense!)
Sort: Classes/Subjects and NameFull sorted Ascending (out of view in the illustration below)
Which to Show: All fields except the Score field should have the Show box checked. All scores will all be 0! The Grading Period should show since I adjusted the criteria for each term and renamed the query.
Why did I want such a table? It is one of several ways I used to see who needed to do make-up work and for what assignment or test.
Last updated: September 17, 2012