How do you use forms and reports to enter and present database data, and output it to other applications?
Creating and using forms for data entry, creating reports (including grouped reports with totals), printing database results in a range of formats, and exporting data to spreadsheet, word-processing and presentation applications.
An SQA Higher Administration and IT answer on creating and using database forms for data entry, creating reports including grouped reports with totals, printing results in a range of formats, and exporting data to spreadsheet, word-processing and presentation applications.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
Jump to a section
What this key area is asking
Beyond storing and searching data, a database must let users enter data easily and present results clearly. The SQA expects you to create and use forms for data entry, create reports (including grouped reports with totals), print results in a range of formats, and export data to other applications (spreadsheet, word processor, presentation). These finish off the database area and link it to the other IT applications.
Forms for data entry
- Easier, accurate entry: a clear layout, one record at a time, with prompts.
- Controlled input: drop-down lists, required fields, default values and validation reduce errors.
- Simpler and safer: hide fields the user does not need; protect underlying data.
Reports, including grouped reports
A grouped report is ideal when management wants data organised and totalled by category, for example "sales per region" with a subtotal under each region and a total at the end. The report calculates the totals automatically from the data.
Printing and exporting
Database results can be printed in a range of formats: the whole table, a form, a report, or selected records; in portrait or landscape; and scaled to fit the page. The report is normally the neatest printed output.
Data can also be exported to other applications so it is reused without re-keying:
- to a spreadsheet, for further calculation, analysis or charts;
- to a word processor, for example as the data source for a mail merge, or pasted/linked into a report;
- to a presentation, to show key figures to an audience.
Exporting (and the reverse, importing) links the database to the rest of the IT toolkit and avoids re-typing data.
Examples in context
Example 1. A user-friendly order form. A sales database uses a form with a drop-down customer list and default order date so staff enter orders quickly and accurately, with validation stopping invalid quantities. This shows how a form makes entry easier and controls the data.
Example 2. A grouped sales report exported to a spreadsheet. An administrator creates a grouped report of sales by region with subtotals, prints it for the meeting, and exports the figures to a spreadsheet to build a chart and to the word processor for the board report. This illustrates grouped reports, printing and exporting.
Try this
Q1. Describe one advantage of using a form to enter data into a database. [2 marks]
- Cue. A form shows one record at a time in a clear layout with prompts, drop-down lists, required fields and validation, so data is entered in the right fields and more accurately than typing into a table.
Q2. Describe what a grouped report is. [2 marks]
- Cue. A report that arranges records into groups by a chosen field (for example by region) and shows a subtotal for each group and an overall total, presenting the data organised and totalled automatically.
Exam-style practice questions
Practice questions written in the style of SQA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
SQA Higher style4 marksDescribe two advantages of using a form to enter data into a database.Show worked answer →
Worth 4 marks. Describe advantages, two marks each.
Easier, more accurate entry (about 2 marks). A form shows one record at a time in a clear, user-friendly layout, so the user enters data in the right fields, which reduces errors compared with typing into a table. Validation and drop-down lists can be built in.
Controls what is entered (about 2 marks). A form can restrict entry (for example drop-down lists, required fields, default values), so only valid data is entered, and can hide fields the user does not need, protecting the data and simplifying the task.
SQA Higher style4 marksDescribe what a grouped report is and give a benefit of using one.Show worked answer →
Worth 4 marks. Describe the grouped report and a benefit.
Grouped report (about 2 marks). A report that arranges records into groups by a chosen field (for example grouped by region or by customer) and can show a subtotal for each group and an overall total.
Benefit (about 2 marks). It presents data in an organised, readable way and gives totals per group automatically (for example sales per region), so managers can compare groups and see totals at a glance without manual calculation.
Related dot points
- The structure of a relational database (tables, fields, records, data types, primary and foreign keys), and creating relationships between tables, with the advantages of a relational database over a flat-file one.
An SQA Higher Administration and IT answer on the structure of a relational database, covering tables, fields, records, data types, primary and foreign keys, creating relationships between tables, and the advantages of a relational database over a flat-file one.
- Searching a relational database using advanced functions (queries with multiple criteria, AND/OR logic, comparison and wildcard operators, sorting and multi-level sorting) and using calculations in queries and reports (calculated fields and summary totals).
An SQA Higher Administration and IT answer on searching a relational database with advanced functions, covering queries with multiple criteria, AND/OR logic, comparison and wildcard operators, sorting, and using calculations such as calculated fields and summary totals in queries and reports.
- Creating and working with word-processed documents using advanced features (styles, sections, headers and footers, page and section breaks, columns, tables, templates, table of contents, track changes and comments) to produce well-structured business documents.
An SQA Higher Administration and IT answer on advanced word-processing features, covering styles, sections, headers and footers, breaks, columns, tables, templates, a table of contents, track changes and comments, used to produce well-structured business documents.
- Creating and formatting charts from spreadsheet data (choosing an appropriate chart type and adding titles, labels and legends), and printing in a range of views and selections (formulae view, gridlines and headings, fit to page, selected ranges).
An SQA Higher Administration and IT answer on creating and formatting charts from spreadsheet data, choosing an appropriate chart type, and printing in a range of views and selections such as formulae view, gridlines, fit to page and selected ranges.
- Researching information and presenting it effectively, using editing, formatting and reviewing features (master slides, transitions, animations, multimedia and hyperlinks), the notes feature, and managing and printing a presentation in a range of formats (slides, handouts, notes pages).
An SQA Higher Administration and IT answer on presentations, covering researching and presenting information effectively, editing, formatting and reviewing features such as master slides, transitions, animations and hyperlinks, the notes feature, and managing and printing a presentation in a range of formats.