Exam 23: Managing and Reporting Database Information

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

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

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

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

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

A query appears in the Navigation pane.

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

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. 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?

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

In the AutoFormat group, click the ____________________ button to display a gallery of predesigned formats.

Which keyboard shortcut opens the Find and Replace dialog box?

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.

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

If you change your mind after sorting data, you can use the ____________________ command to reverse the action.

Describe the two ways to create a form that were discussed in this lesson. What are the similarities and differences?

You cannot prepare a report manually.

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?

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

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.

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?