Access_Ch05_Crossword

1234567891011
Across
  1. 1. A query that summarizes one field by two or more other category fields.
  2. 6. A join that includes all the records in one table, but only the records in a related table that have a corresponding record in the original table.
  3. 7. The field that provides the data to summarize for the intersection of each column and row of a Crosstab query.
  4. 8. Records that should have a corresponding reference in another table but do not.
  5. 10. A value that is required to run a query (or other object).
  6. 11. A join that includes only records that have corresponding matches in a related table.
Down
  1. 2. A computer language common to database programs that is generally used for selecting or managing data.
  2. 3. A query that changes the value of one or more records.
  3. 4. Two or more records that contain the same data in a field that ought to be unique for each record.
  4. 5. A query that removes records from a table.
  5. 9. A query that changes the entry in one or more fields in multiple records at once.