Microsoft Access

Gain a solid foundation in Microsoft Access and learn the fundamentals of database management.

A woman looking at a computer screen with the screen reflected on her glasses.

Course details

Course duration:

12 weeks course access

Assessment & awards:

Microsoft Access Expert (Office 2019) (MO-500)

Method of Study

Online, flexible

Register for Course

New users will need to create a free account and fill in a short form on FETCH, Ireland's Further Education and Training Hub.

This course operates on a fixed intake basis, with the course beginning on specific dates throughout the year. 

This course will open for registration on 28/07/2025 and will remain open until the course begins on 17/08/2025.

Back to courses

Description

This course provides learners with advanced skills in Microsoft Access 2019, focusing on expert-level database management and development. Learners will master database creation, queries, forms, and reports. After completing the course, learners can register for the Microsoft Office Specialist Access Expert certification (MO-500).

Learning Outcomes

By completing this course you will be able to:

 

  • Manage and modify database structures
  • Create and manage table relationships
  • Design and modify complex queries
  • Develop customized forms and reports
  • Configure form and report controls
  • Print and export data effectively

 

By successfully passing the exam at the end of the course, you will also achieve a Microsoft Access Expert (Office 2019) (MO-500) Certificate, an industry recognised qualification certified by Microsoft.

How it Works

Who can take this course?

This course is available to all adults over the age of 18 resident in the Republic of Ireland.

How do I sign up?

You can sign up for this course by visiting FETCH, Irelands Further Education and Training Hub. You will have to register for an account before you can begin the course.

Who is the provider for this course?

The provider for this course is Cenit College, and your learning will be delivered through the eCollege online learning environment. When you complete your application you will receive an email with your access details, and when you log into the platform you will see details of how to contact your course tutor. You can contact your course tutor at any time, or reach out to Cenit College directly at eCollegeinfo@cenitcollege.ie 

Does the course have prerequisites? 

This is an intermediate level course and previous knowledge of the Microsoft Office suite of applications would be beneficial for learners hoping to take this course.

Does this course have tutor support?

Yes, this course is supported by an online tutor who you will have access to during the course.

What is the exam like on this course?

The Microsoft Office Specialist Access Expert 2019 (MO-500) is conducted online and you have 50 minutes in which to complete the exam. You cannot use study materials during the exam. Your results will be available to you on the day of the exam.

Do I need specific hardware or software?

You will require access to a PC or laptop running a supported version of Microsoft Windows (the most recent version is Windows 11).

No specific software is required for this course. You will be provided with an Office 365 license for access to Microsoft Access.