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