Access 5 Review NP2019

123456789101112131415161718
Across
  1. 3. The question mark is the wildcard character that stands for any ___ character in criteria.
  2. 4. An input ___ is often used for things like zip codes, phone numbers, or social security numbers.
  3. 6. If you set the caption property of a form, the caption text appears in this view.
  4. 10. When you create a ___ query, the value the user enters in the dialog box that appears when the query is run determines the results.
  5. 11. You can retain a history of changes to this type of text field.
  6. 12. Setting the Validation ___ is what causes the proper error message to pop up if a validation rule is violated.
  7. 13. This query wizard asks you to select fields for row headings, column headings, and values.
  8. 17. If you want users to enter a ___ number value, set >0 as the validation rule expression.
  9. 18. You use the ___ property of a query to document the purpose or author of the query.
Down
  1. 1. Use the ___ wizard to create a drop down list in a table of options to use for the field.
  2. 2. A/an ___ function is a function that calculates a statistic, such as a subtotal or average.
  3. 5. Use this as a wildcard with the letter T and N to get TEN, TEEN, and THAN in the results.
  4. 7. The validation rule >#7/4/2020# means the date must be ___ July 4, 2020.
  5. 8. Create a Find ___ query to find all records that do not have matching records in a related table.
  6. 9. When creating a lookup list from an existing table, this is automatically created.
  7. 14. Set format, validation rule, input mask, and other settings for table fields in the ___ properties section of the Design view.
  8. 15. For a Date/Time field, use the ___ property to display the date in a different way (1/1/2020 vs January 1, 2020).
  9. 16. This is an example of one-- !999.000.000
  10. 17. To set a validation rule for an entire table, you must open the ___ sheet for the table.