Name: 

As the amount of data in a database increases, it becomes easier to manage records and find information.

When you enter or edit a record in Form view, Access automatically updates the records in the table.

Descending order sorts numerically from the lowest to the highest number.

After sorting data, you can easily restore the table to its original arrangement.

When you use the Find command, you can search within a specific field, or you can search the entire table.

A query appears in the Navigation pane.

When you create a query, there is no need to identify the fields you want to retrieve and show information because Access automatically shows all of them.

You cannot prepare a report manually.

Data entry keyers must verify the accuracy of the data they enter.

Keyers are employed in every sector of the economy.

____ view enables you to make changes to the form design, such as font styles and colors and pre-designed styles.

When you create a form, you add a new ____ to the database.

When identifying fields in the Form Wizard, the ____ button adds all of the fields to the form.

What type of icon appears in the upper-left corner of a form, indicating that you are editing the record?

Which button is used to update a table?

The ____ button restores sorted records to the original order.

Which keyboard shortcut opens the Find and Replace dialog box?

Access provides a wizard to use a ____ format to create labels.

When you work with a form, ____ view is used for adding, editing, and viewing data.

In a form, you can use the ____ key and arrow keys to move the insertion point among fields.

The Replace command is located on the ____ tab.

Which button do you click to start a query?

The Ascending button is located in the ____ group on the Home tab.

A ____ can make the process of entering data more efficient and more accurate.

Which keyboard shortcut allows you to search for the next occurrence of the search text without opening the Find and Replace dialog box?

You can print a database in ____ view, but when you do, all of the data contained in the database is printed.

Page ____ determines how the report will print on the page.

A ____ is a great way to create an object because it asks you questions about the data you want to include and the format of the data.

FIGURE 23-1

What is displayed in Figure 23-1 above?

FIGURE 23-2

In the query shown in Figure 23-2 above, which two fields will be shown in the query results?

Case 23-1
Ryan works in the main office of a pizza restaurant chain. He is updating a database that contains customer contact information used for deliveries. Since it contains addresses, Ryan will use this database to send the customers a special coupon offer through the mail.

Ryan wants to create mailing labels. Which button should he click?

For bulk mail rates, Ryan must sort the labels by ____.

Case 23-2
Mischa maintains a database for a law firm that has branches in several locations in the state. One of the branches just moved to a new office space. Now she must make changes to the contact information for each employee in the branch.

While using the Find and Replace dialog box, Mischa has found some similar data that shouldn’t be changed. Which button moves to the next occurrence without replacing selected text?

Mischa is pretty confident she can replace the old street address with the new street address. Which command will allow her to make all the replacements without reviewing them first?