Reporting Examples of reports are mailing labels, invoices, sales summaries and telephone lists. A DBMS allows complete control in the design of a report in either a tabular layout (displays data with the fields extending across the page) or a column layout (displays data with the fields going down the page). It is possible to insert headings, sort data, choose the fields, switch fields, change column widths and select records. The purpose of the report determines its content, format and style. Most DBMSs allow different reports to be created from the database for different purposes Before creating a report, the user needs to select the required records by constructing a query. For example, you may not need a mailing label for everybody in the School database. Reports are often based on a query. The next step in creating a report is to select the fields. These fields are placed in appropriate positions, formatted, and sorted. DBMS reports often offer such functions as count, sum, and average to perform calculations on selected fields. Most DBMS reports have the following sections:
Constructing different views Different views of a database are obtained using a form. A form is used to view, enter, and change data in a table. The layout of the form can be changed. The user can position fields, headings, instructions and graphics on the form. A well-designed form provides information explaining the required data and any rules that apply to particular fields. Forms are used to display information for different purposes. Reporting Good Design Principles Before selecting the ‘Print’ command to send the report to the printer, make sure the report has the correct format. When formatting a report, the user needs to adopt good design principles, such as:
|
12 IPT > Stem 2.0 Information Systems and Databases > 5. Other information processes for database information systems >
