Working with field-level properties [Access Validation purposes] - Quiz Explanation
The correct answers are indicated below, along with the text that explains the correct answers.
1.
Which type of control does the Lookup Wizard create?
Please select the best answer.
A.
Text Box
B.
List Box
C.
Tab
D.
Combo Box
Answer D is correct.
The type of control created by the Lookup Wizard is a Combo Box control. None of the other answers represents controls created by the Lookup Wizard.
2.
The Validation Rule property allows you to specify the valid data that can be entered into a field. What does the Input Mask property do for you?
Please select the best answer.
A.
Specifies how to display the data on reports
B.
Controls how the data can be entered by providing a specific format
C.
Displays a custom error message for incorrect data
D.
Creates a combo box to display lookup values
Answer B is correct.
The Input Mask Wizard allows you to specify a mask that controls how the user enters data into a field. All the other answers do not allow you to do this.
3.
What is not a valid reason to specify the correct data type to be used for a field?
Please select the best answer.
A.
Access will run only if you do this.
B.
Access has built-in validation for some data types such as Date/Time, which you can take advantage of.
C.
Using the correct data types enhances performance in some cases.
D.
Some data types take up less space.
Answer A is correct.
Specifying the correct data type has a threefold advantage: You can take advantage of Access's built-in validation of data types, enhance performance, and have your data take up less space. Access will continue to function even if you do not do this, so A is the correct answer.