The Using Databases 6.0 module sets out essential concepts and skills relating to understanding the concept of a database and demonstrating competence in using a database application.
Understanding the structure of a database and being able to carry out common tasks using a standalone database is an important competence for those who deal with large sets of data. The Using Databases module covers the definition of a database and how it is organized, table creation and linking, as well as filters, queries, forms, and reports.
- Understanding databases
- Using the application
- Retrieving information
- 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.
- 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.