Exam 5: Generating Reports From Multiple Worksheets and Workbooks

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

If the Quantity field has "< 50" as its validation rule, and a user tries to enter "100" in the field, Access displays the message in the _____ property.

A check box and a command button display "yes" or "no" answers in a field.

A _____ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

You cannot use the Validation Rule property with Short Text or Date/Time fields.

An aggregate function is _____.

If you do not enter a Caption property for a field, Access uses the field name to label the field.

The _____ property creates an easy-to-use visual guide to help users enter accurate data.