Jan's Working with Databases:

Make Table Query

Home > Jan's CompLit 101 > Working with Databases > Appendix

Example: Make-Table Query

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.

Steps in the process:

Query Design View: Make Table-Zeroes-6thTerm

Query Design View: Zeroes-6thTerm
(Some fields are out of view to the left)

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.

Home > Jan's CompLit 101 > Working with Databases > Appendix

Last updated: September 17, 2012