Learners will develop the skills and knowledge to use database software tools and techniques.
Unit Learning Outcomes
Be able to use database software tools to enter, edit and organise routine data.
A database is a collection of data that is organised in a table consisting of columns (fields) and rows (records) so that it can be easily accessed, managed and updated. Organisations use databases to perform calculations, manage large data sets, present information etc.
- Health centres and hospitals, e.g. doctors, patients, appointments
- Employment, e.g. staff names, payroll, departments
- Libraries, e.g. members, books, loans
Table structure: fields, records; use of data entry form; create new record; add record to table, use of data entry form, create new record, add record, select and update fields, groups of records, field data types (text, number, yes/no, date/time, unique identifier).
Find, search, replace, edit record, sort, filter, use wildcards, use search operators, categories.
Spell check, format, accuracy, consistency, check and remove duplication, verify data, data validation techniques, record housekeeping.
Error messages, field size issues, data types, data validation checks, duplicate records, incorrect format, use of help, FAQs, online tutorials.
Guidelines set by employer or organisation, security of data, backup procedures, data format, compliance and reporting, confidentiality of data, file management procedures, data protection law (GDPR), understand key rights available under data protection law (the right to see what personal data organisations hold about you, to withdraw consent and demand that personal data can be rectified or deleted).
Identify different uses of databases.
Create a database table and enter data into records accurately.
Locate and amend records.
Select and use tools to check records for accuracy.
Identify errors and respond appropriately to ensure database is fit for purpose.
Identify guidelines and procedures for the safe storage and use of data.
Be able to retrieve and print database records to meet requirements.
Use menus or shortcuts, alphabetical sorts, numeric sorts, ascending, descending, filter single criteria, filter multiple criteria, save queries, save output.
Print output meets need and appropriately presented.
Standard reports, customised reports, reports with multiple parameters, check outputs meets need, print output.
Run simple queries to search and retrieve data.
Produce and format reports to output data.
Generate and print reports to present data.