Question 1

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

Accepted Answer

Report Design View in Microsoft Access displays both a horizontal and vertical ruler to help with layout and alignment of report elements.

Question 2

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

Accepted Answer

When selecting a product number in the Label Wizard, the dimensions of the label and the number of columns are automatically set based on the product number chosen.

Question 3

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

D

Question 4

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

Portrait orientation is typically 8.5" wide by 11" tall, while landscape orientation is 11" wide by 8.5" tall.

Question 5

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

Accepted Answer

The tasks that can be accomplished by each of the various report views are not mutually exclusive. Different report views can provide different insights and serve different purposes.

Question 6

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

Accepted Answer

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

Question 7

Grouping means to sort records plus provide extra report sections.

Accepted Answer

Grouping involves sorting records and creating subtotals or additional report sections based on common values in a specific field.

Question 8

You can rename labels in Report Layout View.

Accepted Answer

In Report Layout View, you can select and rename labels by clicking on them and editing the text in the properties pane.

Question 9

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

Accepted Answer

The Record Source property can accept queries as its value.

Question 10

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 allows you to modify report controls while reviewing live data. In this view, you can move and resize controls, adjust their properties, and see how they affect the appearance of the report in real-time. It is a good option for fine-tuning the layout and design of a report. The other views have different purposes: 
- Report View shows the report as it will appear when printed or previewed, but you cannot modify the controls. 
- Print Preview shows how the report will look when printed, but you cannot modify the controls. 
- Design View allows you to modify the report controls and their properties, but you cannot see the live data or the report's appearance.

Question 11

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

Accepted Answer

This could happen if the expression relies on different data sources or if the calculations are being done in different contexts or with different parameters. It may be necessary to reconcile the different sections or investigate why the calculations differ.

Question 12

Calculated expressions start with an equal sign.

Accepted Answer

Calculated expressions in most programming languages start with an equal sign to denote that the expression needs to be evaluated.

Question 13

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

Accepted Answer

This is true. Grouping and sorting can be utilized together on a report to organize and display data in a meaningful way.

Question 14

Reports are changeable objects, meaning you can use them to change data.

Accepted Answer

Reports are used to display data, not to change it.

Question 15

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

Accepted Answer

The Report Wizard automatically applies formatting such as headings, colors, and borders to a report.

Question 16

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

Accepted Answer

Clicking the Back button is a standard feature of wizards that allows users to review and change previous selections.

Question 17

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

Accepted Answer

It is possible to apply multiple grouping orders to a report. For example, a report can be grouped by region, then by product type within each region.

Question 18

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 how the entire report will look when printed, including all pages and formatting. It is the best choice for reviewing the report as it will appear when printed.

Question 19

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 a common report embellishment as they are typically used in software applications, not in written reports. Headers, footers, and multiple fonts/colors are common ways of enhancing the presentation and organization of written reports.

Question 20

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 data and analysis in a clear and organized manner, not to provide a data entry interface. A form or input screen would typically be used for data entry.

Quiz 4: Using Reports

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

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

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

Portrait orientation is 8.5" wide by 13" tall.

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

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

Grouping means to sort records plus provide extra report sections.

You can rename labels in Report Layout View.

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

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

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

Calculated expressions start with an equal sign.

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

Reports are changeable objects, meaning you can use them to change data.

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

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

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

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

Which of the following is NOT a common report embellishment?

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