Question 1

In the expression =Sum([Price]), the ____________________ function is used.

Accepted Answer

Sum

Question 2

To quickly review a report without page breaks use ____________________ View.​

Accepted Answer

Report,
report

Question 3

To reverse an action in Layout view, use the ____________________ button.​

Accepted Answer

Undo,
undo

Question 4

____________________ orientation is 8.5" wide by 11" tall.

Accepted Answer

The answer of ____________________ orientation is 8.5" wide by 11"...

Question 5

Which command can you use to move a control from one section to another on a report?

Accepted Answer

A)  Move 
B)  Place 
C)  Adjust 
D)  Cut 
A)  Move 
B)  Place 
C)  Adjust 
D)  Cut

Question 6

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

Accepted Answer

A) True 
 B)False

Question 7

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Accepted Answer

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

Question 8

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Accepted Answer

A)  ruler 
B)  section header 
C)  launcher 
D)  command line 
A)  ruler 
B)  section header 
C)  launcher 
D)  command line

Question 9

Report Design View displays both a horizontal and a vertical ruler.​

Accepted Answer

A) True 
 B)False

Question 10

The same expression in different sections of a report produces different calculations.

Accepted Answer

A) True 
 B)False

Question 11

You can add a field as a grouping field in which pane?

Accepted Answer

A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total 
A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total

Question 12

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

Accepted Answer

A)  Click a control, then [Shift]+click other controls 
B)  Dragging a selection box 
C)  Clicking in the ruler 
D)  Right-dragging 
A)  Click a control, then [Shift]+click other controls 
B)  Dragging a selection box 
C)  Clicking in the ruler 
D)  Right-dragging

Question 13

Access reports can be created by selecting fields from one or more tables or queries.

Accepted Answer

A) True 
 B)False

Question 14

Which report view's primary purpose is to quickly review the report without page breaks?

Accepted Answer

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

Question 15

Case 4-1 
Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him. 
-Bradley wants to focus on just the details of one of the reports, without seeing the data. Which of the following should he use?

Accepted Answer

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

Question 16

The Report Wizard automatically applies many formatting embellishments to a report.

Accepted Answer

A) True 
 B)False

Question 17

Calculated expressions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 18

The Group Footer section prints ____.

Accepted Answer

A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page 
A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page

Question 19

Reports are changeable objects, meaning​ you can use them to change data.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is the correct expression to count the number of records using a field named City?

Accepted Answer

A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City} 
A)  =Count([City]) 
B)  =Count[City] 
C)  =Count(City) 
D)  =Count{City}

In the expression =Sum([Price]), the ____________________ function is used.

To quickly review a report without page breaks use ____________________ View.

To reverse an action in Layout view, use the ____________________ button.

____________________ orientation is 8.5" wide by 11" tall.

Which command can you use to move a control from one section to another on a report?

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Report Design View displays both a horizontal and a vertical ruler.

The same expression in different sections of a report produces different calculations.

You can add a field as a grouping field in which pane?

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

Access reports can be created by selecting fields from one or more tables or queries.

Which report view's primary purpose is to quickly review the report without page breaks?

The Report Wizard automatically applies many formatting embellishments to a report.

Calculated expressions start with an equal sign.

The Group Footer section prints ____.

Reports are changeable objects, meaning you can use them to change data.

Which of the following is the correct expression to count the number of records using a field named City?

Getting Started With Office 2017

Building and Using Queries

Using Forms

Module 1 Getting Started With Access

Filters

Exam 4: Using Reports

In the expression =Sum([Price]), the ____________________ function is used.

To quickly review a report without page breaks use ____________________ View.​

To reverse an action in Layout view, use the ____________________ button.​

____________________ orientation is 8.5" wide by 11" tall.

Which command can you use to move a control from one section to another on a report?

Reports are view -only objects, meaning they can be used to read and display data but cannot be used to change data.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Report Design View displays both a horizontal and a vertical ruler.​

The same expression in different sections of a report produces different calculations.

You can add a field as a grouping field in which pane?

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

Access reports can be created by selecting fields from one or more tables or queries.

Which report view's primary purpose is to quickly review the report without page breaks?

The Report Wizard automatically applies many formatting embellishments to a report.

Calculated expressions start with an equal sign.

The Group Footer section prints ____.

Reports are changeable objects, meaning​ you can use them to change data.

Which of the following is the correct expression to count the number of records using a field named City?

Getting Started With Office 2017

Building and Using Queries

Using Forms

Module 1 Getting Started With Access

Filters

To quickly review a report without page breaks use ____________________ View.

To reverse an action in Layout view, use the ____________________ button.

Report Design View displays both a horizontal and a vertical ruler.

Reports are changeable objects, meaning you can use them to change data.