Table Design  «Prev  Next»

Field Level Properties and Validation Purposes in MS Access - Quiz

Each question is worth one point. Select the best answer or answers for each question.
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

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

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.
Correct answers:

Your Score: 0