ECDL Advanced Database

Master the operation of databases to organise, extract, view and report on information using advanced data management skills. You will also learn how the variety of ways data can be related and organised, imported, exported and linked.

Completing ECDL Advanced Databases enables learners to demonstrate they have the knowledge and skills to:

  • Understand key concepts of database development and usage.
  • Create a relational database using advanced table creation features and complex relationships between tables.
  • Design and use queries to create a table, update, delete and append data.
  • Refine queries using wildcards, parameters and calculations.
  • Use controls and subforms to enhance forms and improve functionality.
  • Create report controls to perform calculations.
  • Create subreports and enhance report presentation.
  • Enhance productivity by working with macros and use linking and importing features to integrate data.

As a result of completing this ECDL Advanced Module, learners :

  • Become more confident, efficient and effective in using a database application.
  • Can produce better reports with deeper data analysis, and higher quality management information.
  • Can use advanced features in table, query, form and report design.
  • Can use macros within the database application.
  • Are able to import, export and link data.

All ECDL certification testing is performed using the ICS Skills Automated Testing System (ATS). The ATS combines the best of all worlds: authentic candidate experience, cost-effective testing, streamlined processes, consistent scoring, and simplified, paper-free candidate management.

  • Web-based: All tests are performed online over the web, so there is no software for test administrators to install or maintain.
  • Real applications: Test candidates work with actual applications (such as MS Word or Excel) – and not simulated screens. In-application testing ensures candidates have the most authentic test experience.
  • Zero paperwork: Because both candidate testing and candidate administration are entirely online, there are no paper records to store, and candidates receive immediate feedback on their results.
  • Secure storage: The ICS Skills ATS gathers and keeps safe all results and candidate, class and module reports. This central storage of data and minimal handling reduces security and privacy risks.

In addition to ECDL certification tests, the ICS Skills ATS provides a full suite of diagnostic tests. These can be used for pre-training and pre-testing assessments to help identify individual knowledge gaps and training needs.

Information Sheet

Click the link below to view or download an Information Sheet for this Advanced Module in Adobe Acrobat PDF format.

Information Sheet

Official Syllabus

Click the links below to view or download the official ECDL Foundation Syllabus for this Advanced Module in Adobe Acrobat PDF format.

Adv Databases Syllabus 2.0

Sample Tests

The ECDL Foundation provides a selection of sample tests as an aid to test preparation. Each version of the sample test below contains the relevant test materials compressed into a single ZIP file:

MS Windows XP

MS Vista 2007

MS Windows 7 2010



Quick Find

ECDL Modules

ECDL's wide range of Modules offers something for everybody – whatever their particular aptitude, talent or career ambition.

ECDL Certifications

Multi-Module certifications to meet the needs of particular categories of individuals.

Apply here to offer ECDL at your organisation.