Question 1

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 2

You can rename labels in Report Layout View.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Accepted Answer

A) True 
 B)False

Question 5

The report section before a group of records is called the Group ____________________ section.

Accepted Answer

The answer of The report section before a group of...

Question 6

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 7

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 is almost ready to print one of the reports. He wants to review the first page of the report to see how it will look when printed. Which view 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 8

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

Accepted Answer

A) True 
 B)False

Question 9

Calculated expressions start with an equal sign.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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}

Question 12

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. Which of the following will Bradley use if he is looking for the optimal view for changing the positioning of some of his report controls while also reviewing the live data?

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 13

The Page Footer section prints ____.

Accepted Answer

A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records 
A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records

Question 14

[Ctrl][Y] is the quick keystroke for the ____________________ command.

Accepted Answer

The answer of [Ctrl][Y] is the quick keystroke for the...

Question 15

____________________ orientation is 8.5" wide by 11" tall.

Accepted Answer

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

Question 16

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

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

Question 17

Which section prints below the Report Header on page one?

Accepted Answer

A)  Report Header 
B)  Page Header 
C)  Page Footer 
D)  Report Footer 
A)  Report Header 
B)  Page Header 
C)  Page Footer 
D)  Report Footer

Question 18

The Report Footer section prints ____.

Accepted Answer

A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page 
A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page

Question 19

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

Accepted Answer

The answer of In the expression =Sum([Price]), the ____________________ function...

Question 20

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

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

You can rename labels in Report Layout View.

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

The tasks that can be accomplished by each of the various report views are mutually exclusive.

The report section before a group of records is called the Group ____________________ section.

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

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

Calculated expressions start with an equal sign.

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

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

The Page Footer section prints ____.

[Ctrl][Y] is the quick keystroke for the ____________________ command.

____________________ orientation is 8.5" wide by 11" tall.

____________________ orientation is 11" wide by 8.5" tall.

Which section prints below the Report Header on page one?

The Report Footer section prints ____.

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Getting Started With Microsoft Office 2013

Filters

Exam 4: Using Reports

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

You can rename labels in Report Layout View.

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

The tasks that can be accomplished by each of the various report views are mutually exclusive.

The report section before a group of records is called the Group ____________________ section.

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

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow.

Calculated expressions start with an equal sign.

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

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

The Page Footer section prints ____.

[Ctrl][Y] is the quick keystroke for the ____________________ command.

____________________ orientation is 8.5" wide by 11" tall.

____________________ orientation is 11" wide by 8.5" tall.

Which section prints below the Report Header on page one?

The Report Footer section prints ____.

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Getting Started With Microsoft Office 2013

Filters