ECDL advanced database
Introduction
Databases have developed from a simple paper based system to a
dynamic tool that not only creates, but can also implement, extract
and report on the data within the database. ECDL Advanced Database
helps the user to understand the variety of ways that data can be
used to create entity relationship tables. It is aimed at the
person who wishes to prove that their knowledge is beyond that of a
basic user, and is an external qualification accredited by the
British Computer Society.
The training course is largely self study and has a one day
practical training workshop included. Training course materials are
provided which will guide the delegate through the topics required
to pass the examination. The examination is one hour in
duration.
Objectives
- Create tables
- Use queries
- Link forms for multiple usage
- Create reports
- Create macros
- Import and export data
- Link data
- Apply editing techniques to various objects
- Apply layout techniques to various objects
- Use special tools appropriately
Course content
The training course will cover
- Creating tables and understanding the consequences of their
formation
- Understanding and modifying relationships between tables,
including many-to-many and one-to-one
- The creation of query formulas to categorise the data into
information fields for dissection
- Linking entities together to create a solution to the raw data
held within a database.
- Create, calculate and extract data to report and summarise to
an advanced level
Duration: Up to 3 months
Cost: £175 per delegate for individual module,
£600 for all 4 Advanced modules, £725 for a full level 3
qualification—see flyers for details
Induction dates 2011 - 2012
14 September 2011 - webinar
24 January 2012 - webinar
For further information, available dates or booking details
please contact:
Debbie Johnson: debbie.johnson@kent.gov.uk
Ann Hill: ann.hill@kent.gov.uk
Tel: 01622 694532
For information on the full range of Learning and Development
courses please contact:
admin@kentlearninganddevelopment.co.uk