Question 1

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

Accepted Answer

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

Question 2

When the Business Analyst table is related to the Client table, it is possible to view the clients of a given analyst when you are viewing the datasheet for the Business Analyst table.The clients for the analyst will appear below the analyst in a split form .

Accepted Answer

The answer of When the Business Analyst table is related...

Question 3

When an update query is created, a(n)_________________________ row displays in the design grid.

Accepted Answer

The answer of When an update query is created, a(n)_________________________...

Question 4

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 5

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

Accepted Answer

The answer of The property that the value in a...

Question 6

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

Accepted Answer

multivalued

Question 7

Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.

Accepted Answer

The answer of Maintenance of a database can involve the...

Question 8

A secondary key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

foreign

Question 9

To create a multivalued field, create a(n)____________________ field being sure to check the Allow Multiple Values check box.

Accepted Answer

The answer of To create a multivalued field, create a(n)____________________...

Question 10

A(n)_________________________ is a field in one table whose values are required to match a primary key in another table.

Accepted Answer

The answer of A(n)_________________________ is a field in one table...

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

Question 12

A(n)____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

Accepted Answer

The answer of A(n)____________________ is a form that allows you...

Question 13

To create a lookup field, select ____________________ from the menu of available data types.

Accepted Answer

The answer of To create a lookup field, select ____________________...

Question 14

If you add a field to a table and later realize the field is in the wrong location, you can move the field.To move the field, click the ____________________ for the field and then drag the field to the new location.

Accepted Answer

The answer of If you add a field to a...

Question 15

Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.

Accepted Answer

This is because the record with the primary key is likely being referenced by another record in a related table and deleting it would break the referential integrity of the database.

Question 16

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.

Accepted Answer

A default value is a pre-set value that is automatically entered into a field when a new record is created, before the user enters any data.

Question 17

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 18

If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.

Accepted Answer

The answer of If you plan to move your data...

Question 19

To display the Total row in a datasheet, click the Sum button on the Ribbon.

Accepted Answer

The answer of To display the Total row in a...

Question 20

One reason to include a foreign key for a table is to eliminate duplicate records.

Accepted Answer

A foreign key is used to establish a relationship between tables, not to eliminate duplicate records.

Quiz 4: Access: Querying a Database