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