Questions:
Question 1. A required field that is used in entering data is a field that
appears with a specific value.
can be left blank.
cannot be left blank.
is selected from a list of values.
Question 2. Validation text is
an error message that provides instruction on what to fix when an incorrect value is entered into a field.
a list of predefined values that can be entered in a field.
a comparison of values entered in two fields.
a field that requires a value of characters or text only.
Question 3. Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is
Question 4. To reduce problems that may occur in generating queries and reports, you could place lookup values into a
data type.
field.
list.
table.
Question 5. To add a list of available choices to a form, use a(n)
checkbox.
combo box.
option button.
tab control.
Question 6. A bound control
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. A form type that displays records in a tabular format, but has more editing options is a(n)
datasheet form.
multiple items form.
split form.
subform.
Question 8. If you click on the form tool, you will open a(n)
existing form.
new form in design view.
new form in layout view.
wizard to design a form.
Question 9.) In the design view of a form, which of the following would NOT be performed?
Add calculations, controls, pictures, and lines.
Change the size of a form section.
Enter a data value.
Modify the properties of the form.
Question 10. All of the following are aggregate functions EXCEPT
average.
count.
minimum.
subtract.