MOS Access Q2

Renaming or ___________ a table could possibly break the functionality of the database.

• deleting

• describing

• adding

• modifying

A(n) _________________ contains no characters, and you use it to indicate that you know no value exists for a field.

• validation rule

• validation string

• zero-length string

• table property

_________ specifies the text in the error message that appears when users violate a validation rule.

• Validation Text

• Validation String

• Validation Rule

• Multi-valued Lookup Field

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

• Field sizes

• Table Properties

• Field Property

• Quick Start Field

You should always consider _____________ a table before deleting a column(field).

• backing up

• ending relationships

• cloning

• changing the primary key

Before you rename a table or other database object, you should do which of the following?

• Save it

• Close it

• Edit it

• Open it

Which one of the following is NOT a field property?

• Column Template

• Field Size

• Caption

• Allow Zero Length

Which field property requires users to enter data in a specific format?

• Validation Text

• Default Value

• Required

• Input Mask

Which of the following is NOT a way to validate data?

• Data type

• Field Sizes

• Filtering

• Field properties

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

• Attachment

• Multivalued

• Caption

• Validation