Access Module 2 Part 1

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