Edinburgh College Banner

Computing

ICDL Databases Microsoft Access Advanced (Formerly ECDL)

Campus OL - Open Learning/Cross Campus

Qualification SCQF Level 6

Study mode Evening

Duration 41 weeks

Start date Aug 2023

Cost £208
(see funding options)

Course enquiry form

Note your interest for this course.
Enter your full name
Enter your email address
This form collects your name and email address so we can contact you with pre-application information on future courses including application deadlines, campus open days and course information. Read our privacy notice to find out how we collect, store and use your data (and for information on withdrawing your consent).

Course overview

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.

How the course is assessed

  • You will be assessed through online assessments
  • These assessments will be mostly practical
  • There will be some theory testing 

Number of days per week

This is an open-learning course. There will be a cut-off where you will have to have completed the course so be mindful of when you join the course throughout the year in order to give yourself enough time. 
 

Entry requirements

  • Minimum of ECDL (ICDL) Extra or Equivalent
  • You will need to have very competent IT/ computer skills

Information on Tests / Auditions / Interview Requirements

There is 1 diagnostic test and 1 exam for this course and you must sit them at an Edinburgh College campus. 

If you don't sit them at an Edinburgh College campus, you will need to source your own BCS-accredited testing centre and pay their additional fees to use it.

English Proficiency Requirements

IELTS 5.5

Progression and Articulation Routes

  • 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

Career options

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

Study Options

Campus Study mode Start date Duration Cost
OL - Open Learning/Cross Campus Evening 28/08/23 41 Weeks £208

You may also be interested in these courses

Computing

Bootcamp - Beginner -Software (Free course)

This course is free for anyone to enrol. If you are looking to change your career or return to work and are unsure if So...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Open learning

Duration
43 weeks

Computing

Data Science Professional Development Award

Are you in a job where you are using data and want to upskill? looking for something you can study flexibly around your ...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 8

Study mode
Open learning

Duration
20 weeks

Computing

Data Science with Python and R (NPA Level 6) (DDI Funded)

This course is delivered through open learning. The course has an 18-week structure and is guided by lecturer support vi...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Open learning

Duration
19 weeks

Computing

ICDL (Formerly European Computer Driving License) Advanced Microsoft Excel

The International Certificate in Digital Literacy (formerly European Computer Driving Licence (ECDL)) is an Internationa...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Open learning

Duration
41 weeks

Computing

ICDL Microsoft Word Advanced (Formerly ECDL)

The International Certificate in Digital Literacy (formerly European Computer Driving Licence (ECDL)) is an Internationa...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Open learning

Duration
41 weeks

Computing

ICDL Presentation Software Advanced Microsoft PowerPoint (Formerly ECDL)

The International Certificate in Digital Literacy (formerly European Computer Driving Licence (ECDL)) is an Internationa...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Evening

Duration
41 weeks

Computing

CISCO Network Essentials (Fully Funded Course)

This course is ideal for anyone wanting to learn the basics of computer networking, device connectivity and security. It...

Read more and apply

Campus
OL - Open Learning/Cross Campus

Qualification
SCQF Level 6

Study mode
Open learning

Duration
20 weeks