Exam 23: Managing and Reporting Database Information

FIGURE 23-1 What is displayed in Figure 23-1 above?

You can create a report based on a table or a(n) ____________________.

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

The ____ button restores sorted records to the original order.

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

The Replace command is located on the ____ tab.

Avery is a common manufacturer of mailing labels.

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

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

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. For bulk mail rates, Ryan must sort the labels by ____.

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

____________________ view provides a detailed view of the structure of the form, and you can use this view to change the properties and add new fields.

Parentheses are added to field names on the prototype label in the Label Wizard.

Which button is used to update a table?

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

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

Portrait orientation formats the report with the short edge of the page at the top.

Ascending order sorts alphabetically from A to Z.

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