page_1.docx

Page 1 

Question 1.1. (TCO 2) A required field that is used in entering data is a field that (Points : 4)

       appears with a specific value.        can be left blank.        cannot be left blank.        is selected from a list of values.

Question 2.2. (TCO 2) An example of a multiple value field would be (Points : 4)

       a criteria comparison of values in two or more fields.        a default value that appears automatically.        something that appears in a predefined dropdown list.        when more than one data item can be accepted in a single field.

Question 3.3. (TCO 2) Using an input mask, a symbol that will force all characters typed into a field to appear in all caps is (Points : 4)

       >.        ".        '.        <>.

Question 4.4. (TCO 2) An input mask that will NOT store blank spaces in a field value is (Points : 4)

       0.        9.        #.        !.

Question 5.5. (TCO 2) An input mask placed on a form will apply to (Points : 4)

       all forms based on that table.        all forms in the database.        all forms based on that table and the table itself.        that specific form only.

Question 6.6. (TCO 5) All of the following are performed in the design view of a form EXCEPT (Points : 4)

       adding pictures, lines, calculations, and controls.        changing the size of the form sections.        entering a data value.        modifying the properties of a form.

Question 7.7. (TCO 5) A bound control (Points : 4)

       is a textbox that is connected to a field in a query or a table.        contains a formula that displays the result.        is used to display aggregate information.        uses a macro to process field information.

Question 8.8. (TCO 5) All of the following are form creation tools EXCEPT (Points : 4)

       blank form.        form design.        form layout.        form wizard.

Question 9.9. (TCO 5) The title for a form should be placed in the (Points : 4)

       details area.        form header.        textbox in the details area.        textbox in the form header.

Question 10.10. (TCO 5) A data macro (Points : 4)

       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.