How does a business use database software to store, search, sort and report on structured data?
Database software: tables, records, fields and data types, primary keys, designing a database, searching with queries and criteria, sorting, validation, and producing reports from stored data.
A CCEA GCSE Business and Communication Systems answer on database software. Covers tables, records and fields, data types, primary keys, designing a database, searching with queries and criteria, sorting, data validation, and generating reports, applied to business record-keeping.
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
Database software stores structured data so it can be searched, sorted and reported on quickly. This part of Unit 1 expects you to use the vocabulary of a database, tables, records, fields, data types and primary keys, design a simple database, search it with queries and criteria, sort the results, apply validation, and produce reports. Databases are how businesses keep customer, stock and staff records that they can look up in seconds.
Tables, records and fields
A database organises data into one or more tables.
So one customer's name, address and phone number together form a record, while the "Surname" column across all customers is a field. Getting this vocabulary exactly right is worth easy marks.
Data types and validation
Each field is given a data type that controls what can be stored and how it behaves.
Primary keys and designing a database
A primary key is a field whose value is unique for every record, so it identifies each record without confusion.
A good primary key is something that cannot repeat, such as a customer ID or product code, rather than a name (two customers could share a name). When designing a database, a business decides what data it needs to store, splits it into sensible fields, picks an appropriate data type for each, chooses a primary key, and may use more than one table linked together.
Searching with queries
The main reason to use a database is to find data fast.
A query searches the table for records that meet stated criteria (conditions), which can be combined with AND and OR, and the results can be sorted into order. This turns a huge table into exactly the records the business needs in seconds.
Reports
A report presents selected data, often the results of a query, in a tidy, formatted, printable layout, with headings, grouping and totals. A business uses reports to produce, for example, a low-stock list, a mailing list, or a sales summary, ready to print or share.
Why this matters
Databases are how businesses store the large, structured records they rely on, customers, stock, staff, orders, and the value comes from being able to search, sort and report on that data instantly and accurately. Compared with paper, a database is faster to search, avoids duplication, can be updated in one place, secured with passwords and backed up. Examiners reward precise vocabulary (field, record, primary key, query, criteria) and concrete examples of searches and benefits.
Try this
Q1. State what is meant by a primary key. [2 marks]
- Cue. A field that uniquely identifies each record, so no two records have the same value.
Q2. Give two suitable data types for fields in a customer database. [2 marks]
- Cue. Any two: text (name), number or currency (amount owed), date (date joined), yes/no (active member).
Q3. Explain one advantage of using a query to find records. [2 marks]
- Cue. It returns only the records meeting set criteria in seconds, so staff find the data they need far faster and more accurately than searching by hand.
Exam-style practice questions
Practice questions written in the style of CCEA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
CCEA Unit 1 (style)4 marksA garden centre keeps a database of plants. Define the terms field, record and primary key, and give an example of a suitable primary key for this database.Show worked answer →
A 4-mark definition-and-example question testing AO1 and AO2.
A field is a single item or category of data, shown as a column, for example PlantName or Price (1 mark).
A record is all the data about one item, shown as a row, for example all the details of one particular plant (1 mark).
A primary key is a field that uniquely identifies each record, with no two records sharing the same value (1 mark). A suitable primary key here would be a PlantID number given to each plant, because names could repeat but the ID is unique (1 mark). PlantName would be a poor key because two plants could share a name.
CCEA Unit 1 (style)5 marksExplain how a business could use a query to find information in a database, and give two benefits of a database over keeping the same records on paper.Show worked answer →
A 5-mark application question.
A query searches the database for records that meet stated criteria (1 mark). The user sets a condition, for example Stock < 10, or Town = "Belfast" AND Type = "Tree", and the query returns only the matching records (1 mark for the idea of criteria, 1 for a sensible example), which can also be sorted into order.
Benefit one: data can be searched and sorted in seconds, so staff find what they need far faster than flicking through paper (1 mark). Benefit two: the same data is not duplicated and can be updated in one place, kept secure with passwords and backed up, and used to produce reports automatically (1 mark). A strong answer gives a concrete query example and links the benefits to speed, accuracy or security.
Related dot points
- Spreadsheet software: cells, rows and columns, formulae and functions, relative and absolute cell referencing, formatting and validation, charts, sorting and filtering, and modelling with what-if analysis for business decisions.
A CCEA GCSE Business and Communication Systems answer on spreadsheet software. Covers cells, rows and columns, formulae and functions, relative and absolute referencing, number and conditional formatting, sorting and filtering, charts, and modelling with what-if analysis, applied to business calculations.
- Word processing software: creating and editing business documents, formatting text and pages, using tools such as mail merge, tables, templates, spell check and headers and footers, and choosing word processing for the right task.
A CCEA GCSE Business and Communication Systems answer on word processing software. Covers creating and editing documents, character and paragraph formatting, page layout, tables, templates, headers and footers, spell and grammar check, and mail merge, with worked exam technique on producing professional business documents.
- File management: organising files into a logical folder structure, using sensible file names and formats, saving and version control, and the file-handling skills (copy, move, rename, delete, search, compress) needed across the software applications.
A CCEA GCSE Business and Communication Systems answer on file management. Covers folder structures and pathnames, sensible file naming, common file formats, saving and version control, and the practical file-handling skills of copying, moving, renaming, deleting, searching and compressing files.
- Presentation software: building slides with text, images, charts and multimedia, using master slides and templates for consistency, adding transitions and animation, and designing effective slides suited to the audience.
A CCEA GCSE Business and Communication Systems answer on presentation software. Covers building slides with text, images, charts and multimedia, master slides and templates, transitions and animation, speaker notes and handouts, and the design rules for clear, audience-appropriate presentations.
- Implications of digital technology for business and customers: effects on ways of working and jobs, data security threats and protection, and the legislation businesses must follow when handling data and trading online.
A CCEA GCSE Business and Communication Systems answer on the implications of digital technology for business and customers. Covers effects on ways of working and jobs, data security threats and protection methods, and the legislation, such as data protection, that businesses must follow when handling personal data and trading online.