Question
Question 1. Question : (TCO 2) 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.
Comments:
Question 2. Question : (TCO 2) An example of a lookup is
one to a million.
2010.
AL, CA, NC, NY, TX.
IN SSN, Date, 111-22-3333, AZ.
Comments:
Question 3. Question :
(TCO 2) 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.
Comments:
Question 4. Question :
(TCO 2) 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
Comments:
Question 5. Question :
(TCO 2) To add a list of available choices to a form, use a(n)
checkbox.
combo box.
option button.
tab control.
Comments:
Question 6. Question :
(TCO 5) 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.
Comments:
Question 7. Question :
(TCO 5) 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.
Comments:
Question 8. Question :
(TCO 5) 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.
Comments:
Question 9. Question :
(TCO 5) 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.
Comments:
Question 10. Question :
(TCO 5) 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
