Access 5 Review NP2019

3. The question mark is the wildcard character that stands for any ___ character in criteria.
4. An input ___ is often used for things like zip codes, phone numbers, or social security numbers.
6. If you set the caption property of a form, the caption text appears in this view.
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.
11. You can retain a history of changes to this type of text field.
12. Setting the Validation ___ is what causes the proper error message to pop up if a validation rule is violated.
13. This query wizard asks you to select fields for row headings, column headings, and values.
17. If you want users to enter a ___ number value, set >0 as the validation rule expression.
18. You use the ___ property of a query to document the purpose or author of the query.

1. Use the ___ wizard to create a drop down list in a table of options to use for the field.
2. A/an ___ function is a function that calculates a statistic, such as a subtotal or average.
5. Use this as a wildcard with the letter T and N to get TEN, TEEN, and THAN in the results.
7. The validation rule >#7/4/2020# means the date must be ___ July 4, 2020.
8. Create a Find ___ query to find all records that do not have matching records in a related table.
9. When creating a lookup list from an existing table, this is automatically created.
14. Set format, validation rule, input mask, and other settings for table fields in the ___ properties section of the Design view.
15. For a Date/Time field, use the ___ property to display the date in a different way (1/1/2020 vs January 1, 2020).
16. This is an example of one-- !999.000.000
17. To set a validation rule for an entire table, you must open the ___ sheet for the table.