Exam 3: Access 3: Creating Custom Reports

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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.

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

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

(True/False)
4.8/5
(31)

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

(Multiple Choice)
4.7/5
(41)

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.

(Multiple Choice)
4.8/5
(35)

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

(Short Answer)
4.7/5
(38)

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

(Short Answer)
5.0/5
(27)

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

(Multiple Choice)
4.8/5
(36)

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

(Multiple Choice)
4.7/5
(41)

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

(Short Answer)
4.9/5
(33)

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

(Short Answer)
4.8/5
(34)

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.

(Multiple Choice)
4.8/5
(30)

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.

(Short Answer)
4.8/5
(27)

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

(Multiple Choice)
4.9/5
(33)

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

(Multiple Choice)
4.9/5
(37)

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

(Essay)
4.8/5
(36)

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

(Short Answer)
4.8/5
(28)

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. ____________________

(True/False)
4.8/5
(44)

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.

(Short Answer)
4.8/5
(29)

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.

(Multiple Choice)
4.9/5
(38)
Showing 41 - 60 of 66
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)