Exam 12: Creating Database Reports

The summary calculation that calculates the average of all values in the field is ____.

You cannot apply conditional formatting in an Access report.

The summary calculation that calculates the largest value in the field is ____.

Report 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 the Names of customers and their phone numbers, grouped by the City in which they live.

____ view does not include many modification tools, but it shows you report data as you work.

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. Your supervisor wants to see how reports have been modified. How do you use the different views of reports to help you accomplish this task?

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

To switch views, click the View buttons on the status bar

You can save reports as objects in a database, so you can open or print them anytime.

Explain how to apply a theme to a report.

The Report Wizard automatically creates a report based on settings that you specify and displays it in Display Preview.

You access the Conditional Formatting Rules Manager dialog box from the ____ tab in Layout view.

____ view includes many powerful tools for modifying a report, however, it can be a difficult view in which to work because it shows only the structure of the report and not the data contained in it.

The database object from which a report gets its data is known as the ____ source.

A field is composed of two parts: the ____________________ and it associated control.

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. Describe how to change a sales report that contains the names and order amounts of your customers so that any order over $25,000.00, in the Orders column, appears bold.

The ____________________ contains the report name or company logo and appears only at the top of the first page of the report.

All reports are composed of ____, each of which contains specific information.