Access Module 2 Part 1

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