Question 1

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?
A) Click a control, then [Shift]+click other controls
B) Dragging a selection box
C) Clicking in the ruler
D) Right-dragging

Accepted Answer

The answer of Which of the following is NOT a...

Question 2

The Page Footer section prints ____.
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

Accepted Answer

The Page Footer section is designed to print at the bottom of every page in the report.

Question 3

You can add a field as a grouping field in which pane?
A) Properties
B) Field List
C) Toolbox
D) Group, Sort, and Total

Accepted Answer

The "Group, Sort, and Total" pane is specifically designed for grouping and sorting data in a report, so adding a field as a grouping field would be most logical in this pane. The other panes, "Properties," "Field List," and "Toolbox," do not have functionalities for grouping fields.

Question 4

Which two sections can be added to a report if you group records?
A) Group Header and Group Footer
B) Group Header and Detail
C) Group Footer and Detail
D) Group Summary and Detail

Accepted Answer

When you group records, the two sections that can be added to a report are Group Header and Group Footer. The Group Header section is used to display information about the group, while the Group Footer section is used to display summaries or totals for the group.

Question 5

The Page Header section prints ____.
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

Accepted Answer

The Page Header section prints at the top of every page, but below the Report Header on the first page.

Question 6

The Group Header section prints ____.
A) at the top of the first page of the report
B) at the top of every page
C) once for every record
D) before every group of records

Accepted Answer

Group Header section prints before every group of records.

Question 7

Which command can you use to move a control from one section to another on a report?
A) Move
B) Place
C) Adjust
D) Cut

Accepted Answer

The Cut command allows you to remove a control from one section and place it in another section by pasting.

Question 8

The Report Footer section prints ____.
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

Accepted Answer

The Report Footer section prints at the end of the entire report.

Question 9

The Group Footer section prints ____.
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

Accepted Answer

The Group Footer section is printed after every group of records.

Question 10

If a report is too wide, you will see a green error indicator in the ____ corner of the report.
A) upper-right
B) lower-left
C) lower-right
D) upper-left

Accepted Answer

The answer of If a report is too wide, you...

Question 11

In Report Design View, you can use commands on the Align button of the _____ tab.
A) Arrange
B) Design
C) Format
D) Home

Accepted Answer

The Align button is located on the Arrange tab in Report Design View, so the correct answer is A. The Design, Format, and Home tabs do not have an Align button.

Question 12

The Report Header section prints ____.
A) at the top of every page
B) at the top of the first page
C) before every group of records
D) once for every record

Accepted Answer

The Report Header section prints at the top of the first page.

Question 13

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.
A) launcher
B) section header
C) ruler
D) command line

Accepted Answer

The ruler provides a visual reference for the placement of controls and allows for precise adjustments. Moving the controls within the specified mark on the horizontal ruler will ensure that the report fits on one page in the given orientation. The launcher, section header, and command line are all unrelated to controlling the placement of controls on a page.

Question 14

Which command is used to copy a control from one report section to another?
A) Move
B) Second
C) Duplicate
D) Copy

Accepted Answer

The copy command is used to duplicate a control from one report section to another. This allows for easy replication of controls without having to recreate them from scratch.

Question 15

Which section prints below the Report Header on page one?
A) Report Header
B) Page Header
C) Page Footer
D) Report Footer

Accepted Answer

The Page Header section prints below the Report Header on page one.

Question 16

Which section prints once for every record?
A) Group Header
B) Group Footer
C) Report Header
D) Detail

Accepted Answer

Detail section prints once for every record. Group Header and Footer, as well as Report Header, only print once per group or report.

Question 17

Which of the following is the correct expression to count the number of records using a field named City?
A) =Count([City])
B) =Count[City]
C) =Count(City)
D) =Count{City}

Accepted Answer

The correct syntax to count the number of records using a field is to use the Count function and specify the field name inside square brackets, like this: =Count([City]).

Question 18

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?
A) =Sum(Quantity)
B) =Sum[Quantity]
C) =Sum{Quantity}
D) =Sum([Quantity])

Accepted Answer

Using square brackets [] or curly braces {} instead of parentheses () would result in syntax errors. Enclosing the field name within square brackets in option D is the correct syntax for the expression.

Question 19

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.
A) ruler
B) section header
C) launcher
D) command line

Accepted Answer

The ruler in a form provides a visual representation of the boundaries of controls and can be used to select controls that intersect the selection line by clicking in the horizontal or vertical ruler. The section header, launcher, and command line are not relevant to this action.

Question 20

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.
A) Orientation
B) Preview Report
C) Print Preview
D) Preview Orientation

Accepted Answer

The option to view the report in print preview is the best choice to determine whether to change the orientation from portrait to landscape since it allows you to see how the report will actually look when printed. The other options mentioned (Orientation, Preview Report, Preview Orientation) do not provide a visual representation of the report in its final printed form.

Quiz 4: Using Reports

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

The Page Footer section prints ____.

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

Which two sections can be added to a report if you group records?

The Page Header section prints ____.

The Group Header section prints ____.

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

The Report Footer section prints ____.

The Group Footer section prints ____.

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

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

The Report Header section prints ____.

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

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

Which section prints below the Report Header on page one?

Which section prints once for every record?

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

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

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

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.