CS 150 study guide2

CS 150 study guide2 - CS 150 Study Guide: exam 2 Eric...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 150 Study Guide: exam 2 Eric Gilbert 1. Custom Report - produced when you modify a report created by the Report tool or the Report Wizard in Layout or Design View, or when you create a report from scratch in Layout or Design view. 7 Sections of Report (Order: Report header, Page header, Group header, Detail, Group footer, report footer, Page footer) Group, Sort, and Total pane: a pane in Layout and Design views for a report in which you can modify the report’s group fields and sort fields, and the report calculations for the groups. 1) Report header- Appears once at the beginning of a report. Use it for report titles, company logos, report introductions, and cover pages. 2) Page Header- Appears at the top of each page of a report. Use it for column headings, report titles, page numbers, and report dates. If your report has a Report header section, it precedes the first Page Headers section. 3) Group Header- (Primary Key-Customer) (displays the group name and the sort field value for the group) Appears before each group of records that has the same sort field value. Use it to print the group name and the field value that all records in the group have in common. A report can have up to 10 grouping levels. 4) Detail- (records) Appears once for each record in the underlying table or query. Use it to print selected fields from the table or query and to print calculated values. 5) Group Footer- (record subtotals) Appears after each group of records that has the same sort field value. It is usually used to print totals (counts for the records in detail section) for the group. 6) Report footer- (report grand total) Appears once at the end of the report. Use it for report totals and other summary info. 7) Page Footer-
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

CS 150 study guide2 - CS 150 Study Guide: exam 2 Eric...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online