Validating Access Data Fields - Quiz Explanation
The answers you selected are indicated below, along with text that explains the correct answers.
1.
The field property that displays a message when information does not meet the validation rule requirements is:
Please select the best answer.
A.
Caption
B.
Validation Rule
C.
Validation Text
D.
Input Mask
The correct answer is C.
The Validation Text property is where you put the custom message you want displayed when invalid data is entered. None of the other properties does this.
2.
The Validation Rule property is found on which two components of Access?
Please select the best answer.
A.
Report controls and table fields
B.
Form controls and table fields
C.
Form controls and query fields
D.
Table fields and query fields
The correct answer is B.
The Validation Rule property can be found on fields in tables and in controls on forms. It is not found on any other combination of fields listed.
3.
The reason to use custom validation text along with the Validation Rule property is:
Please select the best answer.
A.
Because otherwise no message will be displayed.
B.
It is required by Access.
C.
It allows you to create a more user-friendly message.
D.
You won’t be able to use the Validation Rule otherwise.
The correct answer is C.
Although validation text is not required, by using the Validation Text property, you can create a more user-friendly message. Answers A, B, and D are not true for Access.