Present data

Database Reporting: Presenting Your Data Professionally (Syllabus Section 18.3)

Hello ICT students! You’ve done the hard work: you’ve structured your database, input the data, and run complex queries to find exactly the information you need. But how do you share those brilliant results with the world (or at least, your boss or your examiner)?
This section is all about turning raw query results into a polished, professional report. Think of it as putting the perfect frame around your masterpiece!

The Goal: A Perfect Report Output

A database report is the final, formatted output designed to display data clearly, usually for printing. The key to success here is precision and completeness.

Key Requirement: Displaying Data Clearly

• Display All Data in Full: Every piece of data requested must be visible. If the column width is too narrow, the data will be cut off (truncated), which loses marks! Always adjust column widths so all contents are visible.
• Display All Labels in Full: Similarly, all column headings or field labels must be fully visible and easy to read.
• Set Report Titles: Every report must have a clear, descriptive title to tell the reader exactly what they are looking at.

Common Mistake to Avoid: Accidentally allowing a field name like "EmployeeID" to appear as "EmployeeI..." because the column is too narrow. Always double-check your print preview!

Understanding Report Layout Components

To ensure consistency and clarity, reports use different sections for recurring information, summaries, and titles. These sections are called Headers and Footers. Don't worry if this seems tricky; the names tell you exactly when they appear!

1. Report Header and Report Footer

These appear only once in the entire document.

• Report Header: Appears at the very top of the first page.
  Use: For the main report title, logos, or a general statement about the data set.
• Report Footer: Appears at the very bottom of the last page, after all the data records.
  Use: To display grand totals, overall counts (e.g., "Total number of employees: 450"), or final notes.

2. Page Header and Page Footer

These appear on every single page of the report.

• Page Header: Appears at the top of every page (just below the Report Header on page 1).
  Use: This is essential for repeating column headings (field labels) so the reader knows what data they are looking at on every page.
• Page Footer: Appears at the bottom of every page.
  Use: For standard required information like automatic page numbering (Page 1 of 5), the date the report was run, or the file path/name.

Memory Tip (R vs. P):
The Report sections (Header/Footer) are for things that appear Rarely (once).
The Page sections (Header/Footer) are for things that appear Periodically (on every page).

Controlling Output Layouts (Tabular and Columnar)

When you produce a report, you control the structure of how the individual records are displayed:

1. Tabular Format:

• This is the most common layout, resembling a spreadsheet or table.
• Field labels (titles) are usually in the Page Header.
• Data records flow horizontally, one record per row.

2. Columnar Format:

• This layout lists field labels and data vertically.
• Example:
  Field Name: Sarah
  Date of Birth: 12/05/2005
  Address: 45 High Street
• This format is sometimes used when printing single records (like an employee profile) but is less efficient for large lists.

You must be able to control which fields and labels are displayed and adjust the output layouts as instructed by the task requirements.

Formatting Numeric Data and Alignment

This is where attention to detail is critical. Numbers need to be instantly readable and comparable.

Appropriate Alignment Rules

Alignment refers to whether text or numbers stick to the left, center, or right edge of the cell/space.

• Text Data and Labels: Generally Left-aligned. This makes them easy to read, as English (and most languages) is read from left to right.
• Numeric Data (Numbers, Currency, Percentages): Must be Right-aligned.

Did You Know? We right-align numbers so that the least significant figures (the units, tens, hundreds) line up perfectly. This allows a user to instantly compare the magnitude (size) of the numbers without needing to search for the decimal point. If you were comparing salaries, right alignment makes it immediately clear which number has more digits!

Controlling Numeric Display Format

You must set the specific format for any field containing numerical values (including calculations):

1. Number of Decimal Places:

• This specifies how many digits appear after the decimal point.
• Example: If a question asks for "2 decimal places," you must format the value 42 to display as 42.00.

2. Currency Symbol:

• You must apply the correct currency symbol (e.g., $, £, €) to monetary fields.

3. Percentage Format:

• If a value represents a percentage (like tax rate or discount), ensure the format includes the percentage symbol (%).
  (The software usually multiplies the decimal value by 100 and adds the symbol, so 0.25 displays as 25%).

Key Takeaway: Never leave numeric data as "General" format in a final report. Always apply the correct alignment (Right) and specific formatting (decimals, currency, percentage).