Question 1

When the data in a report is grouped, there are four additional sections.

Accepted Answer

The answer of When the data in a report is...

Question 2

When you view a report in Print Preview, you can make changes to the report.

Accepted Answer

Print Preview is only for previewing the report and does not allow editing or making changes.

Question 3

When you click the Group & Sort button on the Format tab, Access produces an 'Add a group and sort' button at the bottom of the screen.

Accepted Answer

The answer of When you click the Group & Sort...

Question 4

Modified Multiple Choice When working on a report in Layout view, you can make additional layout changes by using the _____ tab(s).
A) External Data
B) Arrange
C) Database Tools
D) Page Setup

Accepted Answer

The answer of Modified Multiple Choice When working on a...

Question 5

When you create an initial report using the Report Wizard, you can customize the report using either Layout view or Design view.

Accepted Answer

The Report Wizard in database software like Microsoft Access allows you to create a report, and you can further customize it using Layout view for quick adjustments or Design view for more detailed modifications.

Question 6

To calculate the total of amount paid values, click the Totals button on the Format tab and then click Totals on the list of available calculations.

Accepted Answer

The answer of To calculate the total of amount paid...

Question 7

The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.

Accepted Answer

The Report Footer section prints once at the end of the entire report, not at the bottom of each page. Page numbers and dates are typically placed in the Page Footer section.

Question 8

Modified Multiple Choice The three types of controls that can appear on a report are _____.
A) bound
B) aggregate
C) unbound
D) calculated

Accepted Answer

The answer of Modified Multiple Choice The three types of...

Question 9

To add more space between groups, enlarge the group header or group footer.

Accepted Answer

Enlarging the group header or group footer will add more space between groups in a report.

Question 10

The contents of the Report Header section print once at the beginning of the report.

Accepted Answer

The Report Header section is designed to print its contents once at the beginning of the report, typically used for titles or introductory information.

Question 11

Modified Multiple Choice Available aggregate functions for use in a report include _____.
A) Count Records
B) Count Values
C) Variance
D) Standard Deviation

Accepted Answer

Count Records, Count Values, Variance, and Standard Deviation are all available aggregate functions for use in a report.

Question 12

Design view is most useful when the changes you need to make to a report are especially complex.

Accepted Answer

Design view allows for detailed and precise modifications to a report's structure and layout, making it ideal for complex changes.

Question 13

The contents of the Page Header section print once at the top of each page and typically contain the column headings.

Accepted Answer

The Page Header section is designed to repeat at the top of each page, often including column headings for easy reference across multiple pages.

Question 14

Once you decide on a general report style, you should stick with it throughout your database.

Accepted Answer

Maintaining a consistent report style ensures uniformity, making it easier for users to understand and navigate the database.

Question 15

The contents of the Detail section print once for each record in the table.

Accepted Answer

The Detail section in a report is designed to repeat for each record in the data source, displaying the data for each individual record.

Question 16

Modified Multiple Choice When working with a report in Access, the different ways you can view the report include _____.
A) Report view
B) Print Preview
C) Design view
D) Layout view

Accepted Answer

All four options listed are different views that are available when working with a report in Access, making them all valid choices for the question.

Question 17

A form is the appropriate choice if it is necessary to print data.

Accepted Answer

Forms are typically used for data entry and interaction, not specifically for printing data. Reports are more suitable for printing purposes.

Question 18

The various objects on a report are called tools.

Accepted Answer

The various objects on a report are not called tools. They are called elements or components. Tools refer to the software used to create the report.

Question 19

In Layout view of a report, you can specify both grouping and sorting.

Accepted Answer

In Layout view, you can add groupings and sortings to your report, allowing you to organize and display your data in a meaningful way.

Question 20

Modified Multiple Choice For both grouping and sorting, there is a More button that you can click if you need to specify additional options. The options you then could select include _____.
A) Additional Sort
B) Value
C) Title
D) Totals

Accepted Answer

The answer of Modified Multiple Choice For both grouping and...

Quiz 5: Creating Reports and Forms