Exam 5: Modifying the Database Structure Question

Explore all topics

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 .

(True/False)

4.8/5

(63)

Question 61

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

(Multiple Choice)

4.9/5

(77)

Question 62

A printout of the Relationships window is called the _______________ report.

(Short Answer)

4.8/5

(76)

Question 63

After creating the table pictured above, Grant wants to allow only dates on or after January 1, 2008, in the TourStartDate field. What entries would he use for the Validation Rule and Validation Text properties for this field?

(Short Answer)

4.8/5

(71)

Question 64

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

(Multiple Choice)

4.8/5

(75)

Question 65

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

(True/False)

4.7/5

(79)

Question 66

This data type sequences each new record with the next available integer.

(Multiple Choice)

4.8/5

(71)

Question 67

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

(Multiple Choice)

4.8/5

(79)

Question 68

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

(Short Answer)

4.9/5

(86)

Question 69

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

(Multiple Choice)

4.8/5

(69)

Question 70

The ____ key field is the linking field on the "many" side of the relationship.

(Multiple Choice)

4.8/5

(89)

Question 71

Showing 61 - 71 of 71

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 figure above, item 2 points to a(n)____.

A printout of the Relationships window is called the _______________ report.

After creating the table pictured above, Grant wants to allow only dates on or after January 1, 2008, in the TourStartDate field. What entries would he use for the Validation Rule and Validation Text properties for this field?

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

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

This data type sequences each new record with the next available integer.

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

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

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

The ____ key field is the linking field on the "many" side of the relationship.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters