Question 1

(CO 2) A default value is

• a predefined list of values that can be selected by the user.

• a value that cannot be lower or higher than the selected limit.

• a specific value that automatically appears in a field and has edit capabilities.

• a specific value that automatically appears in a field that cannot be changed by the user.

Question 2

(CO 2) When entering data into a field, which of the following would require the user to input a value that is higher than a zero?

• 0

• >0

• =>0

• >=0>

Question 3

(CO 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.

Question 4

(CO 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 group

• Lookup wizard

Question 5

(CO 2) All of the following items can be modified except

• background color.

• size.

• font.

• records.

Question 6

(CO 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.

Question 7

(CO 5) A calculated control is

• a bound box.

• a text box containing a description.

• an unbound box that the user will fill in with a numeric value.

• contains a formula that displays the result.

Question 8

(CO 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.

Question 9

(CO 5) 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

(CO 5) Use the arrange form layout tool to

• change the form layout

• move fields

• insert space.

• All of the above