Question

6) To set up validation fields, switch to __design_____________ view and in the ________________ __________________ pane add the validation information.

7) ___________________ data types do not allow you to Require an entry into the field.

8) When you add validation text to a field, the validation text will display when a __________________ occurs. Validation text is a ________________ error message and provides feedback about the incorrectly entered data.

10) A comparative operator written like this __________________, is not acceptable for a data validation rule.

13) A ______________field is great for a field with a limited number of values. This field make your data uniform and consistent.

14) When the ______________________ check box in the Lookup Field Wizard is checked then the field will only use values found in the lookup table.

Answer 1

6)

Answer: To set up validation fields, switch to design view and in the ‘Field Properties’ pane add the validation information.

Screenshot:

7)

Answer: AutoNumber data types do not allow you to Require an entry into the field.

Screenshot:

8)

Answer: When you add validation text to a field, the validation text will display when a ‘validation error’ occurs. Validation text is a configurable user-friendly error message and provides feedback about the incorrectly entered data.

Example and screenshot: Suppose the LevelID in the table is configured to be less than or equal to 3 as below:

When the user enters incorrect value against the validation, below message is displayed which is configured in ‘Validation Text’:

10)

Answer: A comparative operator written like this => is not acceptable for a data validation rule.

Screenshot: When => is provided, the user will get below message while saving the changes:

13).

Answer: A ‘Lookup Wizard’ field is great for a field with a limited number of values. This field make your data uniform and consistent.

Screenshot: The user will be able to select M or F, predefined values in the list for the Gender field:

14)

Answer: When the ‘Limit to List’ check box in the Lookup Field Wizard is checked then the field will only use values found in the lookup table.

Screenshot: The table will not accept any value other than M and F for gender field: