Question 1

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

Accepted Answer

False

Question 2

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 or data in a structured and organized manner to inform the reader about a particular topic. The purpose of a data entry interface is to enable the user to input data into a digital system. These are two distinct purposes and are not interchangeable.

Question 3

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 is the report view that displays how the entire report will look like when printed, including all the pages. It allows the user to review and adjust the layout and formatting before printing the report.

Question 4

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

Accepted Answer

It is possible to apply multiple grouping orders to a report in order to organize and analyze data in different ways. This can be useful for generating different types of insights and understanding complex data relationships.

Question 5

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. Headers, footers, and multiple fonts/colors are common embellishments that can enhance the appearance and organization of a report. Command buttons are typically used in software applications to initiate an action or command, but they are not necessary in a report.

Question 6

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 may overlap or complement each other, depending on the specific type and purpose of the report. Therefore, the statement is false.

Question 7

Grouping means to sort records plus provide extra report sections.

Accepted Answer

Grouping involves sorting records into groups based on a common field, and then generating extra report sections for each group.

Question 8

Portrait orientation is 8.5" wide by 13" tall.

Accepted Answer

Portrait orientation is actually 8.5" tall by 11" wide.

Question 9

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

Accepted Answer

Report Design View in Microsoft Access displays both a horizontal and a vertical ruler to help with positioning and sizing objects on the report.

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

Yes, it is possible to group and sort records on the same report. Grouping is done to group together data based on a common field, while sorting is done to arrange the data in order based on a particular field or set of fields. This can be useful for creating summary or aggregated reports where data needs to be grouped and sorted in a specific way.

Question 12

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

Accepted Answer

This is possible if the variables used in the expression are defined differently or if the sections use different data. It is important to verify the consistency of the data and variables throughout the report to ensure accurate calculations.

Question 13

You can rename labels in Report Layout View.

Accepted Answer

In Report Layout View, you can select a label and change its text in the Properties pane, thus renaming it.

Question 14

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

Accepted Answer

The Back button is designed to allow users to review and navigate back to previous dialog boxes in a wizard.

Question 15

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 16

Calculated expressions start with an equal sign.

Accepted Answer

This is true, in many programming languages and spreadsheet programs, calculated expressions start with an equal sign.

Question 17

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

Accepted Answer

The Record Source property can be a query, table, or SQL statement.

Question 18

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 viewing live data. It is a hybrid view that provides some of the functionality of both Design View and Report View. Design View allows you to modify the structure and layout of a report while not viewing live data. Report View allows you to view the final report output without the ability to modify controls. Print Preview allows you to see how the report will look when printed, but does not allow for editing of controls.

Question 19

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

Accepted Answer

The Report Wizard applies formatting embellishments to the report such as font styles, color schemes, and alignment settings.

Question 20

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 a product number is selected in the Label Wizard, the dimensions of the label and the number of columns are automatically set based on the specifications of the chosen product number.

Quiz 4: Using Reports

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

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

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

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

Which of the following is NOT a common report embellishment?

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

Grouping means to sort records plus provide extra report sections.

Portrait orientation is 8.5" wide by 13" tall.

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

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

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

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

You can rename labels in Report Layout View.

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

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

Calculated expressions start with an equal sign.

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 Report Wizard automatically applies many formatting embellishments to a report.

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

Quiz 4: Using Reports

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

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

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

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

Which of the following is NOT a common report embellishment?

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

Grouping means to sort records plus provide extra report sections.

Portrait orientation is 8.5" wide by 13" tall.

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

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

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

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

You can rename labels in Report Layout View.

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

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

Calculated expressions start with an equal sign.

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 Report Wizard automatically applies many formatting embellishments to a report.

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

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

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

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

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