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 2022

Cost £204
(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 29/08/22 41 Weeks £204

You may also be interested in these courses

Computing

CISCO Cyber Security Essentials (SCP)

If you are interested in a career in Computing, IT or Cyber Security then this is a great addition to your CV.The course...

Read more and apply

Campus
Sighthill Campus

Qualification
SCQF Level 5

Study mode
Part time

Duration
41 weeks

Computing

NPA Computer Games with IT Software (SCP)

THIS COURSE IS FOR SENIOR PHASE  PUPILS WHO ARE STILL AT SCHOOL This course provides a pathway to the Foundation Appren...

Read more and apply

Campus
Milton Road Campus

Qualification
SCQF Level 5

Study mode
Part time

Duration
42 weeks

Computing

Access to Cyber Security, Software Development and Web (NPA and CISCO)

This course is an introduction to all the main areas of computing to build up your skills and help you find what you hav...

Read more and apply

Campus
Milton Road Campus

Qualification
SCQF Level 5

Study mode
Full time

Duration
41 weeks

Computing

Computer Games Development HND

Computer Games Development HND is an innovative course designed to give you an insight into various technologies and tec...

Read more and apply

Campus
Granton Campus

Qualification
SCQF Level 8

Study mode
Full time

Duration
41 weeks

Computing

HNC Computing (Leading to HND Software or Networking)

HNC Computer Science is a stepping stone towards a career in a specialist computing science subject. During this course,...

Read more and apply

Campus
Sighthill Campus

Qualification
SCQF Level 7

Study mode
Full time

Duration
41 weeks

Computing

Cyber Security HND (BEng(Hons) Cyber Security and Forensics

This course runs from August to JuneIf you are looking to study Cyber Skills in January, join us on the Access to Cyber ...

Read more and apply

Campus
Granton Campus

Qualification
SCQF Level 8

Study mode
Full time

Duration
41 weeks

Computing

Cyber Security, Networking and Forensics NPA

Cyber Security, Networking and Forensics are a National Progression Award (NPA) designed to introduce you to the core co...

Read more and apply

Campus
Granton Campus

Qualification
SCQF Level 6

Study mode
Full time

Duration
41 weeks