Writing Experts
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.
Share:
#