MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

Name: ______Date: ______Period: ______

Fill in the Blank

Complete the following sentences by writing the correct word or words in the blanks provided.

1. ______or ______a table could possibly break the functionality of the database.

2. If you want more space to enter or edit a setting in the property box, press Shift+F2 todisplay the ______box.

3. A(n) ______contains no characters, and you use it to indicate that you know novalue exists for a field.

4.______specifies the text in the error message that appears when users violate avalidation rule.

5. The ______property field specifies the text displayed by default as column namesin tables and in labels for forms, reports, and queries.

6. When creating fields, use the commands in the ______group on the Table ToolsFields contextual tab.

7. A(n) ______ is a predefined set of characteristics and properties that describes a field.

8. Creating multivalued fields can be accomplished by using the______ Wizard.

9. The ______Quick Start includes fields for city, state, and zip.

10. You should always consider ______a table before deleting a column.

Multiple Choice

Select the best response for the following statements or questions. Place the letter of the correct answer on the blank provided.

_____ 1.To rename a table or other database object, first

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Save it

b. Close it

c. Rename it

d. Open it

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 2.If you delete a database table,

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. You cannot undo the action.

b. Click Undo to restore the table.
c. It is still available in the Navigation Pane.

d. The data is transferred to the Clipboard.

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 3.A complete list of field properties is available in

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. The Navigation Pane

b. Datasheet View

c. Design View

d. All of the above

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 4.Which of the following is not a field property?

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Column Template

b. Field Size

c. Caption

d. Allow Zero Length

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 5.Which field property requires users to enter data in a specifi c format?

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Validation Text

b. Default Value

c. Required

d. Input Mask

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 6.The Append Only property applies only to a field that is set to

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Memo

b. Number

c. Currency

d. Text

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 7.Which of the following is not a way to validate data?

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Data type

b. Field sizes

c. Filtering

d. Field properties

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 8.The Caption field property is used for which field?

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Text

b. Attachment

c. Date/Time

d. All of the above

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 9.Which type of field allows you to select more than one choice from a list?

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Attachment

b. Multivalued

c. Caption

d. Validation

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

_____ 10.To delete a field in Datasheet view, select the column, right-click, and then click DeleteField from the

MOAC Access Lesson 4Modify Tables and FieldsKnowledge Assessment

a. Quick Access toolbar

b. Lookup Wizard

c. Shortcut menu

d. Home tab