FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Access: Maintaining a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

-To add the Book Rep and Customer tables to the Relationships window shown in the accompanying figure,tap or click the Add button in the ___________________ dialog box.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

A(n) ____ query adds a group of records from one table to the end of another table.

To use Filter By Form to filter records,tap or click the ____ button on the HOME tab and then click Filter By Form.

You can use the asterisk (*)wildcard in a filter but not the question mark (?)wildcard.

Four types of filters are available in Access: Filter By Selection,Common Filters,Filter By Form,and Advanced Filter/Sort.

To find records in one table that have no matching records in another table,use the _____ Query Wizard.

You cannot preview the data to be updated in an update query before actually performing the update.

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

A lookup field allows the user to select from a list of values when updating the contents of a field.

To use the shortcut menu to create an update query,press and hold or right-click any open area in the upper pane,point to ____ on the shortcut menu,and then tap or click Update Query on the submenu that appears.

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

To filter records using complex criteria,tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.

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

To specify that entries in the Returns field must be between $0.00 and $30,000.00,enter ____ in the Validation Rule property box.

-To move to the first record using the form shown in the accompanying figure,tap or click the ____ button on the Navigation bar.

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

-To open the Relationships window in the accompanying figure,tap or click the _________________________ button on the DATABASE TOOLS tab.

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

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