Question 1

Which of the following is NOT a common report embellishment?
A) Headers
B) Footers
C) Multiple fonts and colors
D) Command Buttons

Accepted Answer

Command buttons are not considered a common report embellishment. Headers, footers, and multiple fonts/colors are often used to enhance the visual appeal and organization of reports.

Question 2

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

Accepted Answer

The Report Wizard does apply formatting embellishments to a report to make it visually appealing and easy to read.

Question 3

Access reports can be created by selecting fields from one or more tables or queries.

Accepted Answer

Access reports can be customized by selecting fields from tables or queries.

Question 4

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

Accepted Answer

This statement is true. You can apply multiple grouping orders to a report in order to organize and group data by different categories.

Question 5

Calculated expressions start with an equal sign.

Accepted Answer

Calculated expressions in Excel always start with an equal sign, which tells Excel to calculate the formula or expression that follows.

Question 6

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?
A) Report View
B) Layout View
C) Design View
D) Print Preview

Accepted Answer

Print Preview allows you to see the entire report as it will appear when printed, page by page. This view is useful to review and make any final adjustments to the report layout and formatting before printing. Report View is for viewing the report's contents only, Layout View is for designing the report layout, and Design View is for editing the report's properties and data sources.

Question 7

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 prints after every group of records.

Question 8

Which report view's primary purpose is to quickly review the report without page breaks?
A) Print Preview
B) Layout View
C) Design View
D) Report View

Accepted Answer

The answer of Which report view's primary purpose is to...

Question 9

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 10

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

Accepted Answer

This statement is false. Report views serve different purposes and can be used to accomplish different tasks, but they are not mutually exclusive. For example, a summary view can be used to see an overview of data, while a detail view can be used to examine individual records in more depth. Both views can provide valuable insights and accomplish different tasks.

Question 11

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 guide for aligning and moving controls within a given mark on the horizontal axis, allowing you to fit your report onto one page in a specific orientation. The launcher, section header, and command line are not relevant to this task.

Question 12

You can both group and sort records on the same report.

Accepted Answer

Yes, it is possible to both group and sort records on the same report in most database software and reporting tools. This allows for more organized and structured presentation of data.

Question 13

The same expression in different sections of a report produces different calculations.

Accepted Answer

If the expression is used with different inputs or variables in different sections of a report, it can produce different calculations.

Question 14

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?
A) Report View
B) Print Preview
C) Layout View
D) Design View

Accepted Answer

Layout View is the only report view that allows you to modify report controls while reviewing live data. In Layout View, you can make changes to the report layout and formatting, and see the effects of those changes in real-time. This is particularly useful when you need to fine-tune the layout or adjust the spacing of controls to make the report more readable. The other report views (Report View, Print Preview, and Design View) are useful for other tasks, such as reviewing the report content or making complex design changes.

Question 15

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

The answer of Portrait orientation is 8.5" wide by 13"...

Question 16

When using a wizard, you can click the Back button to review previous dialog boxes.

Accepted Answer

Clicking the Back button in a wizard allows you to go back and review previous steps in the process.

Question 17

Grouping means to sort records plus provide extra report sections.

Accepted Answer

Grouping involves sorting records based on certain criteria and also adding additional report sections based on those criteria.

Question 18

You can rename labels in Report Layout View.

Accepted Answer

In Report Layout View, you can click on a label and edit its text to rename it.

Question 19

The purpose of a report is to provide an easy-to-use data entry interface.

Accepted Answer

The purpose of a report is to present information, findings, and recommendations in a structured format to aid decision making. It is not designed for data entry.

Question 20

In the accompanying figure, item 2 points to a Group Footer section.

Accepted Answer

The answer of  In the accompanying figure, item 2...

Quiz 4: Using Forms

Which of the following is NOT a common report embellishment?

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

Access reports can be created by selecting fields from one or more tables or queries.

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

Calculated expressions start with an equal sign.

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

The Group Footer section prints ____.

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

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