Access Module 2 Part 1

Edit Answers
1234567891011121314151617
Across
  1. 4. Change the Unique Values property to this to omit duplicate records in a query
  2. 5. Select this to find the largest amount paid for a client
  3. 7. To change the design of the query click this on the shortcut menu
  4. 9. Click this to change the caption for a field in the query
  5. 10. Click this button to create a new query
  6. 11. Enter this to include calculated fields in queries
  7. 13. Click this to include the total row in the design grid
  8. 17. To save a query, click the save button located here
Down
  1. 1. This operator allows you to search for a range of values in one field
  2. 2. Click this to use the expression builder to create a calculated field
  3. 3. Include these in calculations to indicate which calculation should come first
  4. 6. Less than and greater than are examples of these
  5. 8. Click this to export data from a query to excel
  6. 12. The parameter must be closed in these
  7. 14. To order the records in the answer to a query in a particular way, you do this to records
  8. 15. Select this to calculate the statistics for only records that satisfy certain criteria
  9. 16. Click this to display the entire entry for a calculated field