Deck 7: Creating Custom Reports

Question 1

What is a grouping field?

Answer 1

Grouping field is a report sort field which includes a Group header section before a group of records with the same sort field value and a Group footer section after the group of records in a database.
• Group header section will display the group name and the sort field value of that group.
• Group Footer section will display subtotals or counts of the records in that particular group.

Question 2

List and describe the seven sections of an Access report.

Answer 2

Following are the seven sections of an Access report:
1. Report Header Section
2. Page Header Section
3. Group Header Section
4. Detail Section
5. Group Footer section
6. Page Footer section
7. Report Footer Section
Report Header Section:
• This section only appears once at the beginning of the report.
• It is used to mention the report titles, company logos, report introductions, dates, and visual elements such as lines, cover pages etc.
Page Header Section:
• It appears at the top of the each page of the report.
• It is used for page numbers, column, headings, report titles, and report dates.
Group Header Section:
• It appears before each group of records that share the same sort field value.
• It displays the group name and sort field value of the group.
Detail Section:
• It contains the controls which display the field values for each record in the record source.
Group Footer section:
• It appears after each group of records. It is used to display subtotals or counts for the records in the group.
Page Footer section:
• It appears in the bottom of every page of the report.
• It is generally used to display page numbers, brief explanations of symbols or abbreviations.
Report Footer Section:
• It appears only once at the end of the report.
• It is used for report totals and other information.

Question 3

What is a detail report? A summary report?

Answer 3

Detail Report:
• It is report which displays all fields for every record from record source in the detail section.
Summary Report:
• It is a report which displays only the summary information like totals subtotals etc.
• Detailed information is not specified in summary report.

Question 4

The
property prints a group header on a page only if there is enough room on the page to print the first detail record for the group; otherwise, the group header prints at the top of the next page.

Question 5

section appears by itself at the top of a page, and the detail lines for the section appear on the previous page.

Question 6

The
property, when set to Yes, expands a text box vertically to fit the field value when a report is printed, previewed, or viewed in Layout and Report views.

Question 7

Why might you want to hide duplicate values in a report?

Question 8

What is the function and syntax to print the current date in a report?

Question 9

How do you insert a page number in the Page Header section?

Question 10

Clicking the Title button in the Header/Footer group on the DESIGN tab adds a report title to the
section.

Question 11

What is a multiple-column report?

Question 12

What is a custom report?

Question 13

You can view a report in Report view. What other actions can you perform in Report view?