Exam 5: Using Reports

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Which Short Text field property should you use to specify whether an entry was required for the field?

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

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

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

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

The Field Size property is not available for Currency fields.

The Input Mask property contains how many parts?

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

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

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

You can enter optional field descriptions in Table ____ View.

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

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

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

In the accompanying figure, explain why using an employee s last name as the primary key field in the Employees table does not constitute good database design.

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

In the accompanying figure, the data type for the PaymentAmt field is ____________________.

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

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