ICDL Professional Databases (Advanced) MQF 4

Entry Requirements

Learners should have the ICDL Workforce certification

Duration

14 week course with 3 contact hours per week

Learning Outcomes

“The ICDL Professional Databases (Advanced) module is designed to develop essential concepts and demonstrating competence in using a database application.

Knowledge

  • Understand the key concepts of database development and use.
  • Recognise different types of database models including hierarchical, relational, and object-oriented.
  • Understand relational database structures and table relationships.
  • Understand the use of queries for data manipulation and retrieval.
  • Understand the use of controls and form components in databases.
  • Understand report structures and their analytical use in databases.
  • Understand how macros and integration tools improve efficiency.

Skills

  • Explain the purposes and benefits of different database structures.
  • Create relational databases using advanced table creation features.
  • Establish complex relationships between tables, such as one-to-one, one-to-many, and many-to-many.
  • Design and use queries to create, update, delete, and append data.
  • Refine queries using wildcards, parameters, and calculations.
  • Use controls and subforms to enhance form usability.
  • Create and manage input masks and validation rules.
  • Create report controls to perform calculations.
  • Develop subreports and enhance the presentation of reports.
  • Enhance productivity by using macros.
  • Use linking, embedding, and importing features to integrate data from various sources.
  • Manage permissions and access for data protection.

Competences

  • Apply conceptual understanding to select appropriate database models for specific use cases.
  • Design and structure databases efficiently for real-life applications.
  • Manage and retrieve data effectively to support decision-making and analysis.
  • Design user-friendly and reliable input interfaces to improve data accuracy.
  • Generate informative and functional reports for stakeholders.
  • Optimise database functionality and maintain secure, accessible systems in collaborative environments.
    “

Delivery Method

Online lessons

Certification/Award

To receive individual certification from ICDL Malta, participants must achieve a score of 75% or higher in the ICDL Malta exam.

Exam

This course will lead the learner to the ICDL exam, for which learners must apply either through the examinations department or through any ICDL institute of their choice

Language of instruction

Bilingual