Exam 16: Access 2013 : Modifying the Database Structure

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Field descriptions may be entered in Table Design View._________________________

Which of the following is NOT a good candidate for a primary key field for a Customer table?

-In the accompanying figure,item 2 points to a(n)____.

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

>=#1 / 1 / 93# is an example of an entry for which property for a Date / Time field?

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

The Field Properties pane displays information for how many fields at the same time?

____ properties allow you to supply a drop-down list of values for a field.

____________________ is the data type for the SalesNo field in the accompanying figure.

The process of removing and fixing orphan records is often called ____.

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

A(n)____ key field is the field used on the "one" side of a one-to-many relationship.

-In the accompanying figure,identify the "one" and "many" tables.Identify the "parent" and "child" tables.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

-Using the accompanying figure,explain the term "orphan record" and how to avoid creating one in the Donations table.

To quickly remove all Lookup properties,change the Display Control property to Combo Box. _________________________

To move a field list in the Relationships window,drag the table's primary key field._________________________