Question 1

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

Accepted Answer

A) True 
 B)False

Question 2

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 3

To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.

Accepted Answer

A) Filter 
B) Remove 
C) Advanced 
D) Select

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

You can add a record to a table by ____.

Accepted Answer

A) clicking the New (blank) record button on the Navigation bar 
B) pressing CTRL+PLUS SIGN (+) 
C) clicking the New button 
D) pressing the INSERT key

Question 6

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

Question 7

To order the records in the Account table by city in alphabetical order, use the ____ button.

Accepted Answer

A) Order Ascending 
B) Sort 
C) Sort Ascending 
D) Ascending

Question 8

To create an update query, create a new query and then click the ____ button on the DESIGN tab.

Accepted Answer

A) Query Type 
B) Action 
C) Update 
D) Data Definition

Question 9

Validation rules are rules that a user must follow when entering the data.

Accepted Answer

A) True 
 B)False

Question 10

Computations available for the Total row in a column that contains currency include ____.

Accepted Answer

A) Sum 
B) Square Root 
C) Average 
D) Count

Question 11

To specify that a field is to be required, change the value for the _____ property from No to Yes.

Accepted Answer

A) Required 
B) No Blanks 
C) Necessary 
D) Completed

Question 12

When you use a split form, you only can add records using the simple form.

Accepted Answer

A) True 
 B)False

Question 13

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.

Accepted Answer

A) Change 
B) Edit 
C) Design 
D) Datasheet

Question 14

Case 3-2
​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes.
-Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

Accepted Answer

The answer of Case 3-2
​PrattLast has just realized that they...

Question 15

You can search for a record in Form view but not in Datasheet view.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

Accepted Answer

A) insert-table 
B) new-table 
C) add-table 
D) make-table

Question 18

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

When you create a calculated field, users can update the field.

Accepted Answer

A) True 
 B)False

Exam 13: Access_Module_3

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

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.

To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.

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

You can add a record to a table by ____.

Maintaining a database can include ____.

To order the records in the Account table by city in alphabetical order, use the ____ button.

To create an update query, create a new query and then click the ____ button on the DESIGN tab.

Validation rules are rules that a user must follow when entering the data.

Computations available for the Total row in a column that contains currency include ____.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

When you use a split form, you only can add records using the simple form.

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.

Case 3-2 PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes. -Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

You can search for a record in Form view but not in Datasheet view.

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

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

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

When you create a calculated field, users can update the field.

Exam 13: Access_Module_3

The Unfilter button toggles between filtered and unfiltered displays of the records in a table.

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.

To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters.

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

You can add a record to a table by ____.

Maintaining a database can include ____.

To order the records in the Account table by city in alphabetical order, use the ____ button.

To create an update query, create a new query and then click the ____ button on the DESIGN tab.

Validation rules are rules that a user must follow when entering the data.

Computations available for the Total row in a column that contains currency include ____.

To specify that a field is to be required, change the value for the _____ property from No to Yes.

When you use a split form, you only can add records using the simple form.

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.

Case 3-2 ​PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes. -Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?

You can search for a record in Form view but not in Datasheet view.

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

A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.

To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in the datasheet with the major key on the right.

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

When you create a calculated field, users can update the field.

Case 3-2 PrattLast has just realized that they need to make some additional changes to the Account table. They have asked you to make these changes. -Because PrattLast may move the database to SQL Server, they have decided to delete the Resources Needed field. How do you delete the field?