Filters
Question type

Study Flashcards

A typical Group Footer section will include which type of data?


A) a count or subtotal for records in that group
B) the date and time the report was generated
C) the report page number
D) detail fields for all records included in the group

E) All of the above
F) B) and C)

Correct Answer

verifed

verified

A sort field must also be designated as a____________________field in order to include a Group Header and a Group Footer section in the report for a group.

Correct Answer

verifed

verified

When the Title button on the Design tab is used to insert a title on a report, the title is added to the ___________________ section by default.

Correct Answer

verifed

verified

Which of the following is an advantage of using a query as a record source for a report?


A) a query contains only simple data fields
B) a query includes only one table
C) fields can easily be added to a query as report requirements change, including calculated fields
D) fields from a query record source do not require additional property changes

E) None of the above
F) A) and D)

Correct Answer

verifed

verified

Match Each of the Following

Premises
The control used to zoom in or out at variable increments in report view.
A formatted output (screen display or printout)of the contents of one or more tables in a database.
A section that appears by itself at the bottom of a page.
A field used to group the detail items in a report.
The section of a report that usually displays the group name and the sort field value for the group.
The section of a report that usually displays subtotals or counts for records in a group.
The type of report that displays detailed information by displaying fields from the record source in the Detail section of the report.
The type of report that displays summary information, such as grand totals and/or subtotals, using fields from a record source.
A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.
The control on the status bar used in report view to zoom in or out in 10% increments.
Responses
Group Footer
detail report
orphaned footer section
report
summary report
orphaned header section
Zoom
Zoom slider
Group Header
group band field

Correct Answer

The control used to zoom in or out at variable increments in report view.
A formatted output (screen display or printout)of the contents of one or more tables in a database.
A section that appears by itself at the bottom of a page.
A field used to group the detail items in a report.
The section of a report that usually displays the group name and the sort field value for the group.
The section of a report that usually displays subtotals or counts for records in a group.
The type of report that displays detailed information by displaying fields from the record source in the Detail section of the report.
The type of report that displays summary information, such as grand totals and/or subtotals, using fields from a record source.
A section that appears by itself at the top of a page and the detail lines for the section appear on the previous page.
The control on the status bar used in report view to zoom in or out in 10% increments.

In the expression =Date() , used to return the current date, which portion of the expression is the name of the function?


A) =
B) Date()
C) Date
D) =Date

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

Which section contains content that will appear at the top of every page of a report?


A) Group Header
B) Report Header
C) Page Header
D) Document Header

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.


A) Format
B) Print
C) Arrange
D) Page Setup

E) A) and B)
F) B) and D)

Correct Answer

verifed

verified

The combination of the keys ____________________on the keyboard will select all items in a report when viewing a report in Report view.

Correct Answer

verifed

verified

When you copy information contained  in an Access object such as a report, it is placed on the __________.

Correct Answer

verifed

verified

Which control format property adds comma separators and two decimal places in report Design view.


A) Standard
B) Currency
C) Fixed
D) General Number

E) A) and B)
F) A) and D)

Correct Answer

verifed

verified

A ____________________ report prints the same collection of field values in two or more sets across a page.

Correct Answer

verifed

verified

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.


A) Page Header section
B) Group Header section
C) Report Header Section
D) Detail section

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

Access allows the creation of mailing labels based on manufacturer templates or custom formatted labels.

A) True
B) False

Correct Answer

verifed

verified

Use the Visible property in a report to hide a control when the control's value is the same as the value of the preceding record in the group. ____________________

A) True
B) False

Correct Answer

verifed

verified

Discuss four report design guidelines that should be followed when planning a report design.

Correct Answer

verifed

verified

1. Determine the purpose of the report a...

View Answer

Use the ____________________ to quickly create labels based on uniquely identified label templates.

Correct Answer

verifed

verified

The ____________________ section in Design view appears at the top of each page of a report and usually contains page numbers, column headings, report titles, and report dates.

Correct Answer

verifed

verified

To zoom in or out when viewing a report, use ____________________ to view the report.

Correct Answer

verifed

verified

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.


A) padding
B) keep whole group together on one page
C) keep header and first record together on one page
D) do not keep group together on one page

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

Showing 41 - 60 of 66

Related Exams

Show Answer