ICDL Databases Microsoft Access Advanced (Formerly ECDL)

Course description

The International Certificate in Digital Literacy (formerly European Computer Driving Licence (ECDL)) is an Internationally recognised qualification that enables individuals to develop their competence in computer skills.

This is a highly sought-after qualification by most businesses and enhances any current employment. This formal qualification will provide you with a better understanding of computer programs you may have to use at work. You will gain digital literacy skills and improve your productivity and efficiency when using computers.

The Advanced Microsoft Access module is designed to develop your skills and knowledge in the use of more advanced operations associated with Microsoft Access. 

The qualification leads to a BCS, British Computer Society Certificate

A Windows device is a requirement as the learning materials are not compatible with Macs and other platforms

What you will learn

• 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 using linking and importing features to integrate data.

Learning outcome

• A variety of digital based college courses in the areas of computing and Business at SCQF Level 6
• You may need to have other qualifications or experience to complement this certificate depending on your chosen course

• This qualification enhances the chance of promotion and is useful for careers in Data Science.