Question 1

The Page Header section prints ____.

Accepted Answer

A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records 
A)  at the top of the first page 
B)  at the top of every page (but below the Report Header on the first page) 
C)  before every group of records 
D)  after every group of records

Question 2

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

Accepted Answer

A)  =Sum(Quantity) 
B)  =Sum[Quantity] 
C)  =Sum{Quantity} 
D)  =Sum([Quantity]) 
A)  =Sum(Quantity) 
B)  =Sum[Quantity] 
C)  =Sum{Quantity} 
D)  =Sum([Quantity])

Question 3

Grouping means to sort records plus provide extra report sections.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of To reverse an action in Layout view,...

Question 5

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

Accepted Answer

A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left 
A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left

Question 6

Critical Thinking Questions 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 7

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 8

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

Accepted Answer

The answer of Use the Group, Sort, and ____________________ pane...

Question 9

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 10

Calculated expressions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 11

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

Accepted Answer

The answer of Use the alignment buttons on the ____________________...

Question 13

You can apply more than one grouping order to a report.

Accepted Answer

A) True 
 B)False

Question 14

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

Accepted Answer

Reports are read-only objects, meaning y

Question 15

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

The Page Header section prints ____.

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

Grouping means to sort records plus provide extra report sections.

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

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

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

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

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

Calculated expressions start with an equal sign.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

You can apply more than one grouping order to a report.

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

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

Getting Started With Access

Building and Using Queries

Using Forms

Getting Started With Office 2016

Filters

Exam 4: Using Reports

The Page Header section prints ____.

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

Grouping means to sort records plus provide extra report sections.

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

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

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

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

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

Calculated expressions start with an equal sign.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

You can apply more than one grouping order to a report.

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

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

Getting Started With Access

Building and Using Queries

Using Forms

Getting Started With Office 2016

Filters