Week 5 : Forms, Normalization, and
Validation – Quiz
Question 1. 1. (TCO 2) A required field that is used in entering data is a field that (Points : 4)
appears with a specific value.
can be left blank.
cannot be left blank.
is selected from a list of values.
Question 2. 2. (TCO 2) An example of a lookup is (Points : 4)
one to a million.
2010.
AL, CA, NC, NY, TX.
SSN, Date, 111-22-3333, AZ.
Question 3. 3. (TCO 2) Using an input mask, a symbol that will force all characters typed into a field to
appear in all caps is (Points : 4)
>.
".
‘.
<>.
Question 4. 4. (TCO 2) Which of the following below will provide the current computer data as a
default? (Points : 4)
–/–/-CurrentDate()
Date
Date()
Question 5. 5. (TCO 2) An input mask that will force characters to be input left to right is (Points : 4)
.
!.
<.
>.
Question 6. 6. (TCO 5) A bound control (Points : 4)
always contains a label.
contains a calculation.
must be unique and contain a data field from another underlying source.
must contain a formula.
Question 7. 7. (TCO 5) A bound control (Points : 4)
is a textbox that is connected to a field in a query or a table.
contains a formula that displays the result.
is used to display aggregate information.
uses a macro to process field information.
Question 8. 8. (TCO 5) A datasheet form (Points : 4)
is a form that allows the user to change the appearance of the form.
and a table are the same thing.
entry by a user is always linked to the content of a table.
provides the user with the same look as a table.
Question 9. 9. (TCO 5) The title for a form should be placed in the (Points : 4)
details area.
form header.
textbox in the details area.
textbox in the form header.
Question 10. 10. (TCO 5) All of the following are aggregate functions EXCEPT (Points : 4)
average.
count.
minimum.
subtract.
