Present Data
Data presentation in databases is often done through reports. These reports can be formatted and customised to display data in a user-friendly manner.
Producing Reports to Display Data
- Reports should display all the required data and labels in full. For example, if you're creating a sales report, it should include all relevant fields, like product name, quantity sold, and total sales
Using Appropriate Headers and Footers
- Report Header: This appears at the beginning of the report. This is typically where you would put the report title and other introductory information
- Report Footer: This appears at the end of the report. This is where you might put summary or conclusion information
- Page Header: Appears at the top of each page. This might contain the page number and the date
- Page Footer: Appears at the bottom of each page. This might also contain the page number and the date
Setting Report Titles
- The report title should be set in the report header. It should be clear, concise, and accurately reflect the contents of the report
Producing Different Output Layouts
- You can control the display of data and labels in your report. For example, you might choose a tabular format, where data is arranged in rows and columns, or a columnar format, where each data field is listed vertically
Aligning Data and Labels
- Data and labels should be aligned appropriately. For example, numeric data is often right-aligned, and decimal points should be aligned for easy comparison
Controlling the Display Format of Numeric Data
- You can control the number of decimal places displayed, the use of a currency symbol, and the display of percentages. For example, a total sales field might be displayed with two decimal places and a currency symbol