← Administration & IT syllabus

ScotlandAdministration & IT

IT Solutions for Administrators: Databases

3 dot points across 3 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

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.
10 min answer →

What is a relational database, and how are tables linked together?

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.
11 min answer →

How do you search a relational database with complex criteria and add calculations?

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.
10 min answer →