Question 1

In Report Design View,lines can be difficult to find when they are against the edge of a section or the edge of another control.

Accepted Answer

In Report Design View, lines that are placed against the edge of a section or the edge of another control can blend into the background or the adjacent control, making them difficult to see and select.

Question 2

The Group,Sort,and Total pane allows you to open group header and footer sections.

Accepted Answer

The Group, Sort, and Total pane in Access reports allows you to manage grouping levels, including opening group header and footer sections for detailed data organization and summary calculations.

Question 3

In a report,label controls display data from underlying fields.

Accepted Answer

False

Question 4

You can use the Format Painter to format lines,labels,and text boxes.

Accepted Answer

The Format Painter in Microsoft Office applications allows you to copy formatting from one object (including lines, labels, and text boxes) and apply it to another, making it a versatile tool for quickly replicating formatting styles.

Question 5

To move a control from one report section to another,use cut and paste.

Accepted Answer

To move a control from one report section to another, you can use the cut and paste functionality, which removes the control from its original location and allows you to insert it into a new location.

Question 6

Report Design View gives you full control of all aspects of a report.

Accepted Answer

Report Design View allows you to customize, arrange, and style your report in every possible way, giving you full control over its layout, content, formatting, and other aspects.

Question 7

-In the accompanying figure,what is the grouping field?

Accepted Answer

The grouping field is the one around which the data is organized or categorized in a report or database. In this context, "Category" would be the grouping field, as it is likely used to group different tours into categories for easier analysis or presentation.

Question 8

It is necessary for each report to have at least one control in the Detail section.

Accepted Answer

Reports can be designed without any controls in the Detail section, especially if the report is meant to display summary information or if the Detail section is used for other purposes like grouping headers or footers.

Question 9

Conditional formatting allows you to compare the values of one column to another with small data bars.

Accepted Answer

Conditional formatting in spreadsheet applications like Microsoft Excel allows you to apply formats to a cell or range of cells based on conditions you specify, including comparing values across columns and visualizing those comparisons with data bars.

Question 10

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Accepted Answer

Report sections can vary in height, and the report will still display properly as long as the content is correctly formatted and fits within the page layout and design constraints.

Question 11

You use conditional formatting to highlight important data in a report.

Accepted Answer

Conditional formatting can be used to highlight data that meets specific criteria or rules, making it easier to identify important information in a report.

Question 12

Themes can include font,color,and alignment choices.

Accepted Answer

Themes in design, including web and graphic design, can indeed include choices related to font, color, and alignment, as these elements help in creating a cohesive and visually appealing look.

Question 13

-In Report Design View,if you want to view the grouping and sorting fields,click the ____.

Accepted Answer

The Group & Sort button in Report Design View is used to view, add, or modify the grouping and sorting fields in a report, allowing for organized data presentation.

Question 14

Report sections have properties.

Accepted Answer

Report sections, such as headers, footers, and detail sections, have properties that define their appearance and behavior, such as size, visibility, and formatting options.

Question 15

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

Accepted Answer

Double-clicking the Format Painter button allows you to apply the formatting characteristics of the currently selected control to multiple other controls one at a time, not all controls in that section simultaneously.

Question 16

-In the accompanying figure,how many controls are in the Category Header section?

Accepted Answer

The Category Header section typically contains a smaller number of controls, often used for labeling or organizing categories, and in this context, it is indicated that there are 2 controls.

Question 17

-In the accompanying figure,click the button identified as item 1 to change the Force New Page property.

Accepted Answer

The "Force New Page" property is typically modified through a property sheet or dialog box in design view, not by clicking a button directly labeled as "item 1" in a user interface.

Question 18

Compared to forms and datasheets,____ give you more control over how data is printed and greater flexibility in presenting summary information.

Accepted Answer

Reports in database systems like Microsoft Access offer more control over the layout, formatting, and summarization of data for printing than forms, datasheets, macros, or modules. They are specifically designed for creating documents that efficiently present data to users, allowing for detailed customization and the inclusion of summary information such as totals or averages.

Question 19

-In Access parameter reports,you can shorten date criteria by entering only two digits for the year instead of four.

Accepted Answer

In Access, when entering date criteria in parameter reports, you can use two digits for the year, and Access will interpret it based on system settings and context, typically assuming the closest possible year.

Question 20

It is necessary for every report to have Report Header and Report Footer sections.

Accepted Answer

Not every report requires a Report Header or Report Footer section; their inclusion depends on the specific needs and design of the report.

Quiz 19: Access 2013 : Analyzing Data With Reports