WSQ ICDL Microsoft Access
ICDL – Perform Database Functions (Access 2016) EC – 24 Hours
This module enables learners to understand some of 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.
- 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 and create a form to enter, modify and delete records and data in records
- Create routine reports and prepare outputs ready for distribution
Course Reference Number: TGS-2017501106
Duration: 8.30AM-6.00PM (3 days)
ICDL – Perform Advanced Database Functions (Access 2013) EC – 24 Hours
ICDL Advanced Database is a high level certification programme which enables learners to get more from the database application by giving them the skills to use the many advanced tools available in database applications to better manage and organise structured information.Individuals with ICDL Advanced Database certified skills can:
- Produce better reports with deeper data analysis
- Produce higher quality management information
- Use advanced features in table, query, form and report design
- Use macros within the database application
- Import, export and link data
Course Reference Number: TGS-2013501051
Duration: 8.30AM-6.00PM (3 days)