ICDL Databases

It tests practical database competence across five areas: database concepts, tables and relationships, queries, forms, and reports and output. Expect to build and modify tables, define keys and relationships, create queries with criteria, design forms for data entry, and produce formatted reports. The emphasis is on doing tasks in a database application, not reciting theory.

ICDL module tests are generally practical, taken at a computer in a database application, though the global ICDL site does not publish the item format for this module. Confirm the format with your accredited test centre before booking so you can practise in the right way.

The ICDL global site does not state a duration or item count for the Databases module, and these details are set locally. Ask your test centre for the exact timing and number of tasks when you register, then rehearse full tasks under that time limit so pacing is not a surprise on the day.

The passing score is not published on the ICDL global site and is determined by the test centre or national operator. Request the pass mark in writing when you enrol. As a working target, aim to complete every task accurately rather than chasing a specific percentage, since practical tests usually award marks per completed action.

Retake rules are not stated on the ICDL global site; they are set by the test centre or national operator, and some charge a fee per attempt. Ask about the number of permitted attempts, the waiting period and the cost before you sit the test, and check whether your centre offers a discounted re-sit.

Follow the dependency chain: concepts first, then tables and relationships, then queries, then forms, then reports. Queries depend on well-designed tables and correct relationships, and reports usually draw on tables or queries. Studying reports before you are comfortable with criteria and sorting tends to produce shallow understanding.

Typical failures are not setting a primary key, creating relationships without enforcing referential integrity, writing query criteria in the wrong field or with wrong syntax, and producing forms or reports that show the wrong fields or no grouping. Read each task fully and check the result against the requirement before moving on.

No single product is mandated on the global ICDL site. The skills assessed are generic database skills, but the test is taken in whichever application your centre provides, so practise in that application or a close equivalent. Ask the centre which software and version the test uses before you start preparing.

No official study hours are published. Candidates new to databases generally need several weeks of regular hands-on practice to become fluent with table design, relationships, query criteria and report layout. Focus your time on the areas you cannot yet complete without help, and practise full tasks end to end.

The ICDL Foundation states that ICDL is mapped to frameworks and endorsed by governments and industry associations, and that it is adopted by academic institutions and public and private sector employers. Recognition for a specific role or country varies, so check with local employers or your national operator.