Question 1

A multilookup field is a field that contains more than one value.

Accepted Answer

A) True 
 B)False

Question 2

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the ____________________ button on the HOME tab.

Accepted Answer

The answer of To change gridlines in a datasheet, open...

Question 3

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then tap or click the ____ button on the HOME tab to view the results.

Accepted Answer

A)  Filter 
B)  Selection 
C)  Advanced 
D)  Toggle Filter 
A)  Filter 
B)  Selection 
C)  Advanced 
D)  Toggle Filter

Question 4

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

Accepted Answer

The answer of You can restore filter settings that you...

Question 5

To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.

Accepted Answer

A) True 
 B)False

Question 6

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Accepted Answer

A)  T* 
B)  T% 
C)  T> 
D)  T? 
A)  T* 
B)  T% 
C)  T> 
D)  T?

Question 7

Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven guidelines?

Accepted Answer

Seven database maintenance guidelines ar

Question 8

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

Accepted Answer

A) True 
 B)False

Question 9

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

Accepted Answer

The answer of When you have created a filter using...

Question 10

Match between columns
                        Premises: Allows you to delete all the records satisfying some criterion.

Accepted Answer

The Answer of default value and append query and delete is...

Question 11

A(n) ____________________ query adds, deletes, or changes data in a table.

Accepted Answer

The answer of A(n) ____________________ query adds, deletes, or changes...

Question 12

Modified Multiple Choice Maintaining a database can include ____.

Accepted Answer

A)  filtering records 
B)  changing the appearance of a datasheet 
C)  adding new records 
D)  changing the data for existing records 
A)  filtering records 
B)  changing the appearance of a datasheet 
C)  adding new records 
D)  changing the data for existing records

Question 13

When you use Filter By Form to restrict records that appear, you create the filter and then tap or click the ____ button to apply the filter.

Accepted Answer

A)  Apply Filter 
B)  Filter 
C)  Toggle Filter 
D)  Select 
A)  Apply Filter 
B)  Filter 
C)  Toggle Filter 
D)  Select

Question 14

Critical Thinking Questions Case 3-2 Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in the accompanying figure. They have asked you to make these changes. 
   
 Bavant would like to move the Customer Type field in the Customer table. The field should appear before the Book Rep Number field. What do you need to do to move the field?

Accepted Answer

To move the field, click the r

Question 15

The Remove Filter command on the Advanced menu clears all filters.

Accepted Answer

A) True 
 B)False

Question 16

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Accepted Answer

A) True 
 B)False

Question 17

Looking for the customer whose number is PLI22 is an example of searching.

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: Allows you to add the results of a query to a new table.

Accepted Answer

The Answer of required field and update query and default is...

Question 19

To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

Accepted Answer

A)  Statistics 
B)  Add Total 
C)  Insert Total 
D)  Totals 
A)  Statistics 
B)  Add Total 
C)  Insert Total 
D)  Totals

Question 20

The property that the value in a foreign key must match another table's primary key is called _________________________.

Accepted Answer

referentia

A multilookup field is a field that contains more than one value.

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the ____________________ button on the HOME tab.

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then tap or click the ____ button on the HOME tab to view the results.

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven guidelines?

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

A(n) ____________________ query adds, deletes, or changes data in a table.

Modified Multiple Choice Maintaining a database can include ____.

When you use Filter By Form to restrict records that appear, you create the filter and then tap or click the ____ button to apply the filter.

The Remove Filter command on the Advanced menu clears all filters.

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Looking for the customer whose number is PLI22 is an example of searching.

To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

The property that the value in a foreign key must match another table's primary key is called _________________________.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Creating Reports and Forms

Multiple-Table Forms

Advanced Report Techniques

Filters

Exam 5: Maintaining a Database

A multilookup field is a field that contains more than one value.

To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the ____________________ button on the HOME tab.

When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then tap or click the ____ button on the HOME tab to view the results.

You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.

To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven guidelines?

Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and removing existing fields.

When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

A(n) ____________________ query adds, deletes, or changes data in a table.

Modified Multiple Choice Maintaining a database can include ____.

When you use Filter By Form to restrict records that appear, you create the filter and then tap or click the ____ button to apply the filter.

The Remove Filter command on the Advanced menu clears all filters.

Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the relationships.

Looking for the customer whose number is PLI22 is an example of searching.

To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

The property that the value in a foreign key must match another table's primary key is called _________________________.

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Databases and Database Objects: an Introduction

Querying a Database

Creating Reports and Forms

Multiple-Table Forms

Advanced Report Techniques

Filters