Using Databases

  • Intermediate
  • 24 Hours / 3 Days

This module develops work-based skills. It will enable you to understand the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.

Other Standard Modules

ON COMPLETION OF THIS MODULE THE CANDIDATE WILL BE ABLE TO
  • Understand what a database is and how it is organised and operated. 
  • Create a simple database and view the database content in various modes.
  • Create a table; define and modify fields and their properties; enter and edit data in a table.
  • Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database. 
  • Understand what a form is; create a form to enter, modify, and delete records and data in records.
  • Create routine reports and prepare outputs ready for distribution.

Module Overview

  • Key Concepts
  • Database Organisation
  • Relationships
  • Operation
  • Working with Databases
  • Common Tasks
  • Records
  • Designs
  • Main Operations
  • Queries
  • Forms
  • Reports, Data ExportPrinting

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.