Chapter 11

Question 0

A report can be based on a query

Answer 0

true

Question 1

Reports present data in an organized format

Answer 1

true

Question 2

Changes made to a table used in a report are automatically reflected each time a report is displayed.

Answer 2

true

Question 3

The page footer is displayed at the start of the first page on a report

Answer 3

false

Question 4

a report is displayed as an object in the navigation pane

Answer 4

true

Question 5

Can conditional formatting be used to format all negative numbers in red?

Answer 5

yes

Question 6

Report text can be formatted in one of two colors, blue or black.

Answer 6

false

Question 7

Can a graphic be added to a report?

Answer 7

yes

Question 8

Can formatting be changed in report view?

Answer 8

yes

Question 9

a group can be sorted independent of the other data in a record

Answer 9

true

Question 10

landscape is the default page layout for a report

Answer 10

false

Question 11

margins affect how much printed data you can fit on a report

Answer 11

true

Question 12

A report must have at least one numeric field in order for a summary to be displayed

Answer 12

false

Question 13

The Standard Deviation summary option estimates the variance in a group of values

Answer 13

false

Question 14

What does the max summary option determine?

Answer 14

the largest value in a group of values

Question 15

What does a label control describe

Answer 15

nearby data

Question 16

A report can be modified in layout view only

Answer 16

false

Question 17

design view shows the structure of a report

Answer 17

true

Question 18

a text box can contain a calculation

Answer 18

true

Question 19

a report exported as an HTML always looks exactly the same as the Access report

Answer 19

false

Question 20

PDF is a file format that ensures the report looks exactly the same as the Access report

Answer 20

true

Question 21

can a report be posted to a website

Answer 21

yes

Question 22

are calculated fields stored in a table

Answer 22

no

Question 23

A calculated field can refer to a field in another table

Answer 23

true

Question 24

A calculated field can be formatted as currency

Answer 24

true

Question 25

Data from a mail merge can come from an Access query

Answer 25

true

Question 26

A Word document can be formatted for specific Avery mailing labels

Answer 26

true

Question 27

Addresses for mailing labels must be individually typed, even when a database of the names and addresses already exists.

Answer 27

false

Question 28

What does a report do?

Answer 28

presents data from a database in an organized manner

Question 29

A report is formatted in what view

Answer 29

layout

Question 30

What is a report based on

Answer 30

table or query

Question 31

In a report, grouping organizes data based on a specific what?

Answer 31

field

Question 32

what is the main body of a report

Answer 32

detail

Question 33

Which type of field does a report summary provide statistics on?

Answer 33

number

Question 34

``` Which is not a summary that can be added to a report average min count records total ```

Answer 34

total

Question 35

What can a report summary do

Answer 35

count records in a report

Question 36

what can a report summary not do

Answer 36

eliminate duplicate data automatically include a label sort data in chronological order

Question 37

Which summary determines the smallest value in a group of values?

Answer 37

min

Question 38

which summary calculates the total for a group of values

Answer 38

sum

Question 39

converting data to a file so that it can be used by another application

Answer 39

exporting

Question 40

Which export format preserves all of the formatting in a report?

Answer 40

snapshot

Question 41

a calculated field is created where

Answer 41

in a field box of the select query design grid

Question 42

what is a form letter

Answer 42

a word document with merge fields

Question 43

In a word document, placeholders for data from an Access table or query are called

Answer 43

merge fields

Question 44

mail merge is used to

Answer 44

create personalized form letters