Exam 5: Access: Maintaining a Database

To order the records in the Client table in reverse alphabetical order by City, click the ____ button.

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

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

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

Figure 3-2 As an alternate to using the Find button shown in the accompanying figure, you can press ____ to search for a specific record.

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

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

In the JSP Recruiters database, a one-to-many relationship exists between the Recruiter table and the Client table.

Explain what happens if you upsize a database containing multivalued fields to SQL Server.

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

When you use a make-table query to add records to a new table, Access creates the table as part of the process.

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

To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.

To remove a total row that appears in a datasheet, click the ____ button on the Home tab.

Figure 3-2 To use Filter By Selection to find all clients located in Berridge, click the City field for any record where the city is Berridge and then click the ____ button on the Home tab shown in the accompanying figure.

The Find button is available only in Form view.

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

Figure 3-3 The relationship in the accompanying figure was created by clicking the ____________________ check box in the Edit Relationships dialog box.