This module allows candidates to understand the concept of a database and demonstrate competence in using a database.
SYLLABUS
The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.
On completion of this module the candidate will be able to:
- Understand what a database is and how it is organised.
- Create a simple database and view the database content in various modes.
- Create a table, define and modify fields, and create relationships between tables. Enter and edit data in a table.
- Use filters and queries to retrieve specific information from a database.
- Create a form to enter, modify, and delete records and data in records.
- Create routine reports and prepare outputs ready for print or electronic distribution.
WHAT ARE THE BENEFITS OF THIS MODULE?
- Covers the key skills needed to organise and operate a database.
- Can be applied to a range of database software from vendor packages to ‘freeware’.
- Certifies best practice in effective database software use.
- Developed with input from computer users, subject matter experts, and practising computer professionals from all over the world. This process ensures the relevance and range of module content.
SYLLABUS OVERVIEW
| CATEGORY | SKILL SET |
|---|---|
| Understanding Databases |
|
| Using the Application |
|
| Tables |
|
| Retrieving Information |
|
| Forms |
|
| Outputs |
|

