Exam 5: Modifying the Database Structure

Explore all topics

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?

(Essay)

4.9/5

(38)

Question 61

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

(True/False)

4.9/5

(33)

Question 62

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

(Multiple Choice)

4.7/5

(42)

Question 63

For a Date/Time field, use the Format property to display the date 1/17/2017 as January 17, 2017.

(True/False)

4.8/5

(34)

Question 64

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

(Multiple Choice)

4.8/5

(41)

Question 65

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.

(Short Answer)

4.8/5

(41)

Question 66

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

(31)

Question 67

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

(Multiple Choice)

4.8/5

(26)

Question 68

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

(Multiple Choice)

4.8/5

(35)

Question 69

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

(True/False)

4.8/5

(30)

Question 70

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

(True/False)

4.7/5

(36)

Question 71

Showing 61 - 71 of 71

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 Validation Rule property is not used with Text or Date/Time fields.

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

For a Date/Time field, use the Format property to display the date 1/17/2017 as January 17, 2017.

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

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.

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

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

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters