Question 1. A required field that is used in entering data is a field that
appears with a specific value.
IN can be left blank.
cannot be left blank.
is selected from a list of values.
Question 2. An example of a lookup is
one to a million.
2010.
AL, CA, NC, NY, TX.
IN SSN, Date, 111-22-3333, AZ.
Question 3. An input mask
allows one record to have more than two field values.
allows the user to type a social security number as 111223333 and it would display as 111-22-3333.
confirms that a value greater than 100 is a valid value.
is a list of values that are previously defined from which the user can select one item.
Question 4. Which of the following will create a lookup field, populate the values in the field, and establish relationships between tables?
Design View
Fields Group
Lookup List
Lookup Wizard
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. Which statement below best describes how designers and users work with forms?
IN The designer and the users will edit and update forms.
The designer of a form will make it functional and easy to use the first time.
The designer of a form will need to keep revising a form as suggested by the users.
The designer and users will never need to edit a well designed form.
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?
IN 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. A data macro
executes a series of actions when a table event occurs or whenever a named macro is executed.
identifies fields to compare.
is a switchboard.
is a table event