Database Software
Unit summary
This is the ability to use a software application (eg Microsoft Access, Sun Star Office, Apple Works, Filemaker Pro, similar packages or one built for an organisation) designed to organise and collate related information (eg storing addresses and phone numbers).
This involves: entering and retrieving information from databases (eg for names and addresses, stock control, time-management or event-management) by running simple queries; and
producing reports (eg using menus or short cuts).
modifying simple (eg single table, non-relational) databases, creating queries using multiple selection criteria and reports (eg about sales activities, order details or project management).
Unit details
e-skills - e-skills UK (Note: not an awarding body)
-
06 Information and Communication Technology
This unit is based on National Occupational Standards, as defined by e-skills UK.
e-skills UK defined unit.
| Learning Outcome |
Assessment Criteria |
| 1 Know how to use a database |
1.1 Describe what types of information the database has been designed for.
1.2 Describe what types of design content are stored within the database.
1.3 Identify what characteristics in a database fields may have, such as data type, field name, field size and field format.
1.4 Describe how field characteristics can contribute to data validation
1.5 Describe why you would use a form for entering data into a database.
1.6 Describe how to find and retrieve information from a database.
1.7 Describe how data is structured in a simple (eg single-table, non-relational) database.
1.8 Describe why it is important to maintain data integrity. What methods should be used to maintain data integrity in a simple (eg single-table, non-relational) database. |
| 2 Use a database. |
2.1 Use techniques for entering data into databases
2.2 Create fields for entering data with the required field characteristics, name, type, size and format.
2.3 Modifying field characteristics within a simple (e.g. single-table, non-relational) database while maintaining the integrity of existing data, such as name, type and size.
2.4 Check data in databases.
2.5 Using automated facilities for checking data and reports (eg spell checking and sorting data).
2.6 Carry out types of queries
2.7 Produce & format reports
2.8 Improving efficiency (eg Setting up short cuts). |