Question 1

Labels can only be printed in an Access report using the across, then down sequence.

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, which numbered arrow indicates the report results are filtered?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  5

Question 3

A filter may be applied to data when a report is viewed using the Layout view .

Accepted Answer

A) True 
 B)False

Question 4

The Keep Together property, which determines how group data will be printed, is set using the ____________________.

Accepted Answer

The answer of The Keep Together property, which determines how...

Question 5

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report.

Accepted Answer

A) True 
 B)False

Question 6

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group.

Accepted Answer

A) True 
 B)False

Question 7

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Accepted Answer

The answer of Values in a selected column may be...

Question 8

Use the ____________________ to quickly create labels based on uniquely identified label templates.

Accepted Answer

The answer of Use the ____________________ to quickly create labels...

Question 9

By default, the Report tool and the Report Wizard include the page number control in the ____ section.

Accepted Answer

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

Question 10

Layout view must be used to select all controls in a report and to remove an individual control from the selection.

Accepted Answer

A) True 
 B)False

Question 11

Design view should be used to modify a report when the user wants to add lines, rectangles, and other controls only available in Design view .

Accepted Answer

A) True 
 B)False

Question 12

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

Accepted Answer

A)  Can Grow 
B)  Width 
C)  Can Shrink 
D)  Bottom Margin

Question 13

The Detail Section of a report usually contains most of the report contents.

Accepted Answer

A) True 
 B)False

Question 14

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

Accepted Answer

A)  Group Footer 
B)  Page Footer 
C)  Report Footer 
D)  Detail

Question 15

Case Based Critical Thinking Questions Case 7-1
Carlos is not familiar with creating Access reports and has asked his friend Nina to help him create some useful reports from his organic produce farm data. The organic farm currently has three tables, as illustrated below. Using the information provided, determine the best answers for the questions below.

Nina does not see any fields available to add to the report after making the correct selection from the DESIGN tab on the Report Layout Tools Ribbon. What is most likely the problem?

Accepted Answer

A)  no table was selected before beginning the report 
B)  there are no tables in the database 
C)  the tables are not visible in the Field List pane of the report design window and must be made visible 
D)  there are no fields created for the table selected

Question 16

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

Accepted Answer

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

Question 17

Live data is not visible in controls when making changes to a report in Design view.

Accepted Answer

A) True 
 B)False

Question 18

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

Accepted Answer

A)  Page 1 of 3 
B)  Page 1 of 3 pages 
C)  Page 1 of 3 Pages 
D)  1 of 3 Pages

Question 19

In the expression =Date(), used to return the current date, which portion of the expression is the name of the function?

Accepted Answer

A)  = 
B)  Date() 
C)  Date 
D)  =Date

Question 20

In the accompanying figure, which numbered arrow indicates the Report view button.

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5

Exam 3: Access: Creating Custom Reports

Labels can only be printed in an Access report using the across, then down sequence.

In the accompanying figure, which numbered arrow indicates the report results are filtered?

A filter may be applied to data when a report is viewed using the Layout view .

The Keep Together property, which determines how group data will be printed, is set using the ____________________.

The Count Values aggregate function must be selected from the Totals menu to calculate the grand total of a selected column in a report.

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group.

Values in a selected column may be summarized using any of eight ____________________ functions on the Totals menu from the DESIGN tab.

Use the ____________________ to quickly create labels based on uniquely identified label templates.

By default, the Report tool and the Report Wizard include the page number control in the ____ section.

Layout view must be used to select all controls in a report and to remove an individual control from the selection.

Design view should be used to modify a report when the user wants to add lines, rectangles, and other controls only available in Design view .

The text box property that allows the box to expand vertically to fit the field value is the ____ property.

The Detail Section of a report usually contains most of the report contents.

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements.

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

Live data is not visible in controls when making changes to a report in Design view.

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

In the expression =Date() , used to return the current date, which portion of the expression is the name of the function?

In the accompanying figure, which numbered arrow indicates the Report view button.