Unit Award Scheme
118520 USING QUERIES AND SEARCHES IN DATABASES
In successfully completing this unit, the Learner will have | Evidence needed | |
|---|---|---|
demonstrated the ability to | ||
| 1 | open a database application software | Summary sheet |
| 2 | define the data and/or field names that are needed in a single database table | Summary sheet |
| 3 | select at least two different data types to use in the database table | Summary sheet |
| 4 | input sufficient records to allow for meaningful queries or searches | Summary sheet |
| 5 | insert a new record into the table | Summary sheet |
| 6 | edit at least one record by changing or updating the data | Summary sheet |
| 7 | create two different queries or searches using a single criterion | Summary sheet |
| 8 | create a query or search on more than one field using an AND criteria | Summary sheet |
| 9 | sort the results of a serach or query on at least one field | Summary sheet |
| 10 | save their work and exit the software | Summary sheet and/or student completed work |
shown knowledge of | ||
| 11 | at least two ways databases can be used in business and industry. | Summary sheet |
All outcomes recorded on an AQA Summary Sheet
Approved 24 February 2023Level - Level One