Deck 4: Create Reports

Question 1

A selected control in a report displays a(n) ________ border.

A) orange
B) green
C) blue
D) purple

Answer 1

A

Question 2

The ________ tool allows the user to add fields to a report one at a time.

A) Report Generator
B) Designer Report
C) Blank Report
D) Report Maker

Answer 2

C

Question 3

The query that provides the underlying information for the report is known as the ________.

A) legend
B) site map
C) data source
D) prototype

Answer 3

C

Question 4

Which of the following is the correct order of steps for creating a report based on a query?

A) Add fields to the query, add criteria, and build the report using the query.
B) Add criteria, add fields to the query, and build the report using the query.
C) Build the report using the query, add criteria, and add fields to the query.
D) Add fields to the query, build the report using the query, and add criteria.

Question 5

The Query Wizard button is found in the ________ group under the Create tab.

A) Templates
B) Queries
C) Tables
D) Reports

Question 6

To select multiple controls, press and hold ________ while clicking with the pointer.

A) [Esc]
B) [Shift]
C) [Tab]
D) [Alt]

Question 7

Report controls can be formatted using the commands on the ________ tab.

A) Home
B) Format
C) Database Tools
D) File

Question 8

In Print Preview, the Margins button is found in the ________ group.

A) Page Layout
B) Zoom
C) Page Size
D) Data

Question 9

________ is a view optimized for onscreen viewing of reports.

A) Design view
B) Layout view
C) Report view
D) Print Preview

Question 10

The ________ control is the area of a report that repeats for each record.

A) Detail
B) Header
C) Footer
D) Date

Question 11

A theme applies ________ to the report.

A) a font only
B) a set of colors only
C) a font color only
D) a set of fonts and a set of colors

Question 12

When a report is selected, the Themes button is found in the Themes group under the ________ tab.

A) Design
B) Arrange
C) Format
D) Page Setup

Question 13

When a report is open in Layout view, click the ________ button to display the Group, Sort, and Total pane.

A) View
B) Group & Sort
C) Themes
D) Property Sheet

Question 14

Sum, Average, and Count are examples of ________.

A) summary statistics
B) reporting criteria
C) summary calculations
D) categorical statistics

Question 15

Report controls can be formatted using the ________.

A) Property Sheet
B) Group, Sort, and Total pane
C) Page Setup tab
D) Relationships Report

Question 16

To add a blank row at the top of a report you created, click anywhere in the first row of the report and then click the ________ button.

A) Insert Left
B) Insert Below
C) Insert Above
D) Insert Right

Question 17

The average control is available when the Totals button is clicked in the ________ group on the Design tab.

A) Grouping & Totals
B) Views
C) Controls
D) Tools

Question 18

Cells arranged into rows and columns into which controls are placed are known as ________.

A) templates
B) prototypes
C) layouts
D) themes

Question 19

If the entire page of a report does not display in Print Preview view, click the ________ button.

A) Columns
B) One Page
C) Text File
D) More

Question 20

________ view can be used to format a report while viewing the report's data.

A) Layout
B) Design
C) Report
D) Normal

Question 21

A report formatted so that the data can be printed on a sheet of labels is called an address report.

Question 22

You can build a report with fields and criteria from a query.

Question 23

When a report is based on a query, the query criteria is applied to the report.

Question 24

A(n) ________ report is formatted so it can be printed on mailing labels.

A) mail merge
B) label
C) address
D) contact list

Question 25

Click the ________ button to reapply a filter created previously.

A) Filter
B) Refresh
C) View
D) Toggle Filter

Question 26

The Labels button is found in the ________ group on the Create tab.

A) Reports
B) Forms
C) Queries
D) Tables

Question 27

As the name implies, the Blank Report tool opens a new blank report that you can customize and format any way you want.

Question 28

It is NOT necessary to preview a report before printing because it automatically adjusts itself to fit the contents.

Question 29

Fields that contain dates are grouped into yearly quarters by default.

Question 30

When a ________ is applied, only the records that match the criteria display.

A) filter
B) group
C) sort
D) format

Question 31

If you click in a column on a report that displays numbers, what kind of filter choices will be available if you click the Filter button?

A) Number Filters
B) Text Filters
C) Date Filters
D) Wildcards

Question 32

The Select Column button is found in the Rows & Columns group on the ________ tab.

A) Design
B) Arrange
C) Format
D) Page Setup

Question 33

The Date and Time button is located in the ________ group on the Design tab.

A) Tools
B) Controls
C) Themes
D) Header/Footer

Question 34

Users CANNOT make any changes to a theme's set of fonts or colors.

Question 35

You can alternate the color of each record that appears in a report.

Question 36

The ________ tool allows the user to arrange fields in a different layout.

A) Blank Report
B) Report Generator
C) Report Maker
D) Generic Report

Question 37

In Access, the Format Painter can be applied to both data in a table and controls on a report.

Question 38

Each manufacturer identifies its label sheets by using a ________.

A) factory icon
B) product name
C) product number
D) zone label

Question 39

Any filters saved in a report are ________ when you open the report.

A) active
B) deleted
C) not active
D) locked

Question 40

Switch to Print Preview to filter data and drill down to get needed information.

Question 41

When you add filters to an open report, any previous filters do NOT remain in effect.

Question 42

As you add fields with the Blank Report tool, tables move to the upper or lower sections of the Field List pane.

Question 43

The Blank Report tool does NOT make it easy to arrange and format text controls.

Question 44

A picture CANNOT be inserted into the header of a report.

Question 45

The last step in creating a report is determining which fields contain the data you want to see in your report.

Question 46

You can change the color of the banded rows in a report.

Question 47

You add meaning to a report by grouping and sorting it.

Question 48

In a tabular layout, labels are below each column.

Question 49

A report is automatically set to the width of a printed sheet of paper.

Question 50

You can automatically adjust a row's height.

Question 51

In a report, text boxes are labeled by Label controls.

Question 52

The Group, Sort, and Total pane appears when the Group & Sort button is selected.

Question 53

In Print Preview view, a report displays as it will appear on the screen.

Question 54

Fields that contain dates can be grouped by days, months, quarters, and years.

Question 55

Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the Report button.

Question 56

You can add calculations for groups of data such as totals, averages, and counts to report columns.

Question 57

To find the average of a column in a report, use the SUM control.

Question 58

You CANNOT adjust the width of more than one control at a time.

Question 59

In a report, text boxes display data.

Question 60

To copy all the formatting of one control to other controls, use the Format Painter.

Question 61

Once a filter is cleared, it CANNOT be enabled by clicking the Toggle Filter button.

Question 62

Reports can be created quickly by selecting a table or query in the Navigation Pane, and then clicking the ________ button.

Question 63

If you do not see the entire contents of a field, you can adjust the column width to ________.

Question 64

In a report, if you click on a date control and then click the Filter button, Date Filters will be available to you from the Filter list.

Question 65

When a filter is applied to a report, the Toggle Filter button is ________.

Question 66

An Access report CANNOT be used to print mailing labels.

Question 67

Switch to Report view to filter data and drill down to get needed information.

Question 68

A report is more meaningful if its data is ________ and sorted.

Question 69

A filter helps you display only those records in a report that match one or more ________.

Question 70

When printing a label report, most printers will NOT print until a sheet of labels is placed in the manual feed tray.

Question 71

By default, a report is set to the width of a printed sheet of ________.

Question 72

The Label Wizard shows you a prototype of the selected fields and their placement.

Question 73

Reports are often based on ________.

Question 74

Each manufacturer uses a product ________ to identify its label sheets.

Question 75

Use the ________ to modify a report's design.

Question 76

Access formats a label report to match the dimensions of the label size.

Question 77

Because the results you get after applying a filter contain records only with values you selected, the rest of the data remains hidden.

Question 78

When you apply a filter, the Toggle Filter button is NOT active.

Question 79

Hold down ________ while clicking other controls to make adjustments to all of them at the same time.

Question 80

Labels CANNOT be created from tables or queries.