Exam 12: Creating Database Reports

A developer already created a database for the small business you work for. Your supervisor likes the way that the database performs, but needs some changes made to the reports that are part of the database. The "Finance Report" needs a new title. How do you change the title of the "Finance Report" to "Accounts Payable"?

Summaries can include statistics for the sum, average, minimum, or maximum value in any numerical field.

In the accompanying figure, item 3 points to the ____.

The ____________________ contains field labels and appears at the top of every page (below the Report Header on the first page).

You can use ____________________ view to resize, move, and delete columns.

Report data can be from one or multiple database objects.

Explain why you might see the characters ##### in a summary column.

____ organizes a report by field or field values.

You can add fields to a report in Layout view

You can add fields to a report in ____  using the Field list.

Explain why you might want to use conditional formatting.

____ view is the default view when you open a report from the Navigation pane.

You have a database containing customer information, including orders, for a small retail store you work at. The database is relational and the database designer organized the tables so that the columns contain only single pieces of information. For example, the names of customers take up to three fields (First, Middle, and Last Name). Naming conventions in the database use uppercase characters for each word in a field name. Describe how you can create a report that lists only the Last Name and Phone Number for each customer in your database.

When viewing a report, the Zoom Out pointer appears when you place the pointer over the report

In Design view, you can add or delete fields and resize, move, or delete columns while also viewing records

In the accompanying figure, item 2 points to the ____.

You can only print reports on standard sheets of paper.

In the accompanying figure, item 1 points to the ____.

Spotting statistical trends in a large database is usually easy.

In the accompanying figure, item 4 points to the ____.