How does an administrator use a database to store, search, sort and report on information?
The database features used to store and manage information (fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on databases, covering fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports, and how to choose the right feature to manage information.
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 dot point is asking
The SQA wants you to name and describe the database features an administrator uses to store, search, sort and report on information, and to choose the right feature for a task. Questions give a scenario such as a customer or stock list and ask which features would help, so learn the vocabulary (field, record, query, report) precisely.
How a database is organised
A database is a structured store of information. The vocabulary is examined directly, so learn it exactly.
A customer database, for example, has one record per customer, and each record has fields for name, address, phone number and so on. Choosing the right data type for each field matters: storing a phone number as text keeps any leading zero, while storing a price as a number lets it be totalled. Setting up the fields carefully at the start makes searching, sorting and reporting reliable later.
Key features and what they do
Choosing the right feature
The exam rewards matching the feature to the task in the scenario.
Try this
Q1. Define the term "record" in a database. [1 mark]
- Cue. All the fields (pieces of information) stored about one item, such as one customer.
Q2. Describe how a query with criteria would find a group of customers. [2 marks]
- Cue. The query selects only the records that match the conditions set, for example all customers in a chosen town.
Q3. Explain one benefit of using a database rather than paper files. [2 marks]
- Cue. Records can be searched and sorted instantly, so information is found far faster than reading through paper.
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-style Describe4 marksDescribe database features an administrator could use to manage a list of customers.Show worked answer →
Award 1 mark for each feature described, up to 4. Store each customer's details in a record made up of fields such as name, address and phone number (1). Use a search or query with criteria to find a group of customers, for example all those in Glasgow (1). Sort the records into order, for example alphabetically by surname (1). Run a query on more than one criterion, for example customers in Glasgow who spent over a set amount (1). Produce a report to present selected records neatly for printing (1). Markers reward a described feature linked to its purpose, not a one-word list.
SQA-style Explain4 marksExplain the benefits to an organisation of storing information in a database rather than on paper.Show worked answer →
Award marks for explained benefits, up to 4. Information can be searched and found quickly using a query, rather than reading through paper files (1). Records can be sorted into any order instantly, which is slow to do by hand (1). The same data can be reused in mail merge, reports and labels without retyping (1). Records are easy to update, and access can be restricted with passwords to keep data secure (1). It also saves physical storage space (1). Markers reward a clear benefit with its reason.
Related dot points
- The spreadsheet features used to process and present numerical information (formulae and functions such as SUM, AVERAGE, MAX, MIN and IF, formatting, sorting and filtering, charts and graphs), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on spreadsheets, covering formulae and functions (SUM, AVERAGE, MAX, MIN, IF), formatting, sorting and filtering, and charts, and how to choose the right feature to process and present numerical information.
- The word-processing and desktop-publishing features used to create and edit business documents (house style, templates, mail merge, tables, headers and footers, page numbering, find and replace, spellcheck), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on word processing and desktop publishing, covering features such as house style, templates, mail merge, tables, headers and footers, and how to choose the right feature to produce accurate, professional business documents.
- Good electronic file-management practice (clear folder structures, sensible file naming, version control, regular backups) and the use of an electronic diary (e-diary) to schedule appointments, set reminders and manage time.
A focused answer to the SQA National 5 Administration and IT content on electronic file management and electronic diaries, covering folder structures, file naming, version control and backups, and how an e-diary is used to schedule appointments and manage time.
- Methods of keeping people, property and information secure in an organisation (visitor sign-in, ID badges, CCTV, alarms, passwords, backups and access rights), and the main requirements of data protection legislation for handling personal information.
A focused answer to the SQA National 5 Administration and IT content on the security of people, property and information, covering physical and electronic security methods (sign-in, badges, CCTV, passwords, backups) and the main requirements of data protection legislation.
Sources & how we know this
- National 5 Administration and IT Course Specification — SQA (2024)
- National 5 Administration and IT - Course overview — SQA (2024)