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.
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.
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.
Query Design View: Zeroes-6thTerm
(Some fields are out of view to the left)
Query Datasheet View: View query results BEFORE running the query
Why did I want such a table? I don't really remember! It is one of several ways to see who needed to do make-up work and for what assignment or test.
Lessons Databases Appendix
Teachers: Request permission to use this site with your class
Copyright © 1997-2012 Jan Smith <email@example.com>
All Rights Reserved
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~
Last updated: 30 Apr 2012