Exam 16: Access 2013 : Modifying the Database Structure

A field that contains unique information for each record is called a(n)____ field.

A(n)Number data type is used to store values that represent money._________________________

You can modify the Field Size property of a Short Text field._________________________

In the accompanying figure,the data type of the PaymentDate field is ____________________.

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with.Why might a Relationships report help her create the queries?

The Input Mask property contains how many parts?

Modifying the Decimal Places property changes the way the data is presented.

-In the accompanying figure,item 4 references a(n)____.

The ____ property determines whether users can add or edit the list of items in a Lookup field.

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type,then the data type on the foreign key field must be set to AutoNumber._________________________

Changing the Decimal Places property for a field does not change the actual data stored in the field.

When a Caption property is not entered,the field name is used to label the field.

(999)000-000;1;_ would be a possible entry for which field property?

Byte,Long Integer,Single,and Double are examples of entries for which property?

Which of the following is NOT defined in Table Design View?

-In the accompanying figure,explain how two tables are being joined.Mention which tables are being joined,the relationship that is being created,and the fields used to make the connection.

The Validation Rule property is not used with Text or Date / Time fields.

A good Field Size property value for a state abbreviation field is ____.

The ____ property provides a label used to describe the field.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.