Question 1

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Accepted Answer

The answer of The ____________________ source is the table or...

Question 2

The value of the Record Source property may  not be a query.

Accepted Answer

A) True 
 B)False

Question 3

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 ready to print his report, but he only wants to print specific pages of the report. On what tab can he find the options to accomplish this task?

Accepted Answer

A)  Print Preview 
B)  Print Options 
C)  Selection 
D)  Tools

Question 4

Use the Align button on the Design tab to align the edges of the controls with respect to one another. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To view a report to determine whether to change orientation from portrait to landscape, right-click the report in the Navigation Pane and click _____ on the shortcut menu.

Accepted Answer

A)  Orientation 
B)  Preview Report 
C)  Print Preview 
D)  Preview Orientation

Question 8

Arguments are the pieces of information that a functio n needs to create a final answer.

Accepted Answer

A) True 
 B)False

Question 9

In Report Design View, you can use commands on the Align button of the _____ tab.

Accepted Answer

A)  Arrange 
B)  Design 
C)  Format 
D)  Home

Question 10

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

Accepted Answer

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

Question 11

Which of the following is NOT a common report embellishment?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons

Question 12

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

Question 13

You can rename labels in Report Layout View.

Accepted Answer

A) True 
 B)False

Question 14

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 15

By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.

Accepted Answer

A) True 
 B)False

Question 16

Which command is used to copy a control from one report section to another?

Accepted Answer

A)  Move 
B)  Second 
C)  Duplicate 
D)  Copy

Question 17

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}

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Which section prints below the Report Header on page one?

Accepted Answer

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

Question 20

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

Exam 4: Using Reports

The ____________________ source is the table or query that defines the fields and records displayed on a report.

The value of the Record Source property may not be a query.

Use the Align button on the Design tab to align the edges of the controls with respect to one another. _________________________

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

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

To view a report to determine whether to change orientation from portrait to landscape, right-click the report in the Navigation Pane and click _____ on the shortcut menu.

Arguments are the pieces of information that a functio n needs to create a final answer.

In Report Design View, you can use commands on the Align button of the _____ tab.

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

Which of the following is NOT a common report embellishment?

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

You can rename labels in Report Layout View.

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

By selecting a product number in the Label Wizard, you also specify the dimensions of the label and the number of columns.

Which command is used to copy a control from one report section to another?

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

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

Which section prints below the Report Header on page one?

The Page Footer section prints ____.