Detailed · Deep study
1Database reports
| Section | Appears | Typical contents |
|---|---|---|
| report header | once, at the start of the report | report title, logo, date |
| page header | at the top of every page | column labels (field names) |
| detail | once for every record | the field values |
| page footer | at the bottom of every page | page numbers |
| report footer | once, at the end | totals, averages, counts (calculated controls) |
- Display all the required data and labels in full – widen controls so nothing is cut off.
- Set the report title exactly as specified.
- Choose the layout: tabular (records in rows, field names across the top) or columnar (each record shown with labels down the page).
- Align data and labels appropriately: right-align numeric data; use decimal alignment for numbers with decimal places.
- Control number display: decimal places, currency symbol, percentage.
2Exam focus
Key words: report; report header; page header; page footer; report footer; tabular; columnar; alignment.
Quick self-check
Answer in your head first, then reveal.
Report header appears once at the start of the report (1); page header appears at the top of every page (1).
Right-aligned / decimal aligned (1).
