FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Modifying the Database Structure

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

A subdatasheet is used to modify field properties.

Which of the following is a clue that a database needs to be redesigned?

-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.

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

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.

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

A common place to use an Input Mask property would be for a Phone Number field.

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

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

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

-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.

Where do you modify field properties?

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

Each field must be given an associated field description.

-Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

You can modify the Field Size property of a Number 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. _________________________

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