FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Access_Module_3

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the ____ command to display the custom text filters.

A) Text Filters
B) Character Filters
C) Common Filters
D) Common Character Filters

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.

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

If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.

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

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

To save validation rules, default values, and formats, click the Save button on the ____ to save the changes.

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

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

To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the ____ button on the HOME tab.

To move from Layout view to Form view, click the ____ button on the Access status bar.

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

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

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

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

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

To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the ____ button to update the records.

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

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