Microsoft Access 2019 Expert

Name: Microsoft Access 2019 Expert Training Course - Online, Edinburgh & Glasgow | Pitman Traning
Author: admin

About the course

The course offers an exciting and innovative approach to Access training. It consists of 14 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will
help you review what you have learned and assess your understanding.

The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of
the course, you will receive a Pitman Training certificate to verify your achievement.

Course Info

Duration 25 hours. This will vary from individual to individual based on prior knowledge and ability.

Training Type Course

Study Type In centre, Online

Awards & Qualifications

Awarded 25 CPD points upon successful completion

Discounted Training

CITB Members can receive a special discounted rate on our training courses – Click to find out more

Is this course right for me?

Is this course for you?

The course is designed for those who are familiar with Microsoft Access 2019 and who want to learn advanced concepts and techniques to work more productively with the software.

Awarded 25 CPD points upon successful completion

Duration 25 hours. This will vary from individual to individual based on prior knowledge and ability.

Course Content

Course Content

Module 1: Primary Keys and Indexes

Module 2: The Ribbon

Module 3: Using Datasheet View

Module 4: Linking Other Access Databases

Module 5: Using ODBC and SQL Server

Module 6: Splitting an Access Database

Module 7: Macros

Module 8: Introduction to Visual Basic for Applications

Module 9: Visual Basic for Application Coding

Module 10: Access Events Model

Module 11: Forms

Module 12: Advanced Uses of Queries

Module 13: Action Queries

Module 14: Packaging Your Application

Course Overview

Aims and objectives

The aim of the course is for you to learn advanced-level concepts and features of the Microsoft Access 2019 database management application, so that you will be effective in creating, using, and managing databases.

Career Path

Microsoft Access is a very popular database application widely used across many employment sectors to keep accurate, up-to-date records of customers, projects, products, etc. Knowing how to effectively set up and manage databases will be a valuable skillset in many work environments.

Pre-Requisites

This course follows Access 2019.

September 2026

September 3 Microsoft Power BI Introduction -Tutor Led

Microsoft Power BI Introduction -Tutor Led

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

September 3 Assertiveness – 1-day Workshop

Assertiveness – 1-day Workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 4 A.I in the Workplace – 1-day Workshop

A.I in the Workplace – 1-day Workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 8 Management Skills – 1-day Workshop

Management Skills – 1-day Workshop

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

September 8 MS Project Introduction – Tutor Led

MS Project Introduction – Tutor Led

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 9 Negotiation Skills – 1-day Workshop

Negotiation Skills – 1-day Workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 9 PowerPoint Advanced – Tutor Led

PowerPoint Advanced – Tutor Led

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

September 10 Telephone Techniques – 1-day Workshop

Telephone Techniques – 1-day Workshop

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

September 10 Microsoft Word Intermediate – Tutor Led

Microsoft Word Intermediate – Tutor Led

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 11 A.I in the Workplace – 1-day Workshop

A.I in the Workplace – 1-day Workshop

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

September 14 Time Management – 1-day Workshop

Time Management – 1-day Workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

September 14 Microsoft Word Advanced – Tutor Led

Microsoft Word Advanced – Tutor Led

Glasgow 3rd Floor, Tontine House 8 Gordon Street, Glasgow, United Kingdom

Testimonials

‘I found this course hugely beneficial. I have just taken on a training aspect to my current role and the skills gained on this course have given me the confidence to approach the training sessions in a much more positive way.
This course gave me both the knowledge of how to put a training session together, and insight into the different approaches and skills used to deliver the training. I particularly found the practical aspect of the course useful. Throughout the three days, we not only learnt ‘how’ to do various tasks, but actually did, and evaluated them’.

MC—-Project Officer

Organisations Testimonials, Train the Trainer

The skills that I learnt on the course come up time and time again on a daily basis and I am sure that the diploma on my CV has ensured interviews for a number of job applications.

L B – PR Assistant

Private Individuals

“I started studying for a Secretarial Diploma with Pitman training in September 2013. After working as a mail room assistant for years, I wanted to move on to a better job with more opportunities.
I researched courses at various colleges but the hours weren’t suitable for me with a full time job. I liked the flexibility of studying with Pitman, it allowed me to study in my own time and at my own pace. At my first meeting with Linda we chatted about what kind of job I would like to do in the future and what kind of organisation I would like to work for. I had originally been interested in taking an ECDL course but after speaking with Linda we decided that a Secretarial Diploma would give me more opportunities of finding the job I was looking for.
I was very impressed with the course materials and facilities and found the course straightforward and easy to follow. The learning environment is very relaxed and girls are all very friendly and helpful. I have learned so many new skills while studying with Pitman and also learned to feel confident in my abilities. In July 2013 I started working as an administrator in an organisation that I have wanted to work in for several years. My new employer, the Scottish Police Federation was impressed by the qualifications I had earned and with the amount of my own time I had dedicated to studying for them. I love my new job and without all the help I received from Pitman Training I wouldn’t be in the position I am in now.
I want to thank all the staff for all the help you gave me and for making the time I spent at the training centre so enjoyable. I would recommend anyone to take a course with Pitman Training and wouldn’t hesitate to take another course if I feel I need to expand the skills I have learned in the future.”

NM – Secretarial Diploma

General Diploma, Private Individuals, Secretarial Diploma

High praise. Marion drew from her own experiences which I appreciated. She was able to help us with our individual issues. She listed to us and adapted her training to suit our needs.

Alanna – Office Manager/PA – Executive PA Seminar

Executive PA Seminar, General PD, Organisations Testimonials

Julie was an extremely good deliverer of the course content, very knowledgeable. I noticed she never failed to answer any questions and had offered solutions to all issues put to her.

Paul – Scientist – Supervisory Skills

General PD, Organisations Testimonials, Supervisory Skills

I have now come to the end of my courses in finance, and I should like to say how impressed I was with the quality of training I received through them all.
The knowledge I have gained has consolidated and enhanced my previous experience in a number of accounts jobs over the years, and given me new confidence in my skills and abilities to truly pursue bookkeeping as a specialist career. There are certainly many businesses out there that really need competent “accounting technicians”.
As soon as I had completed my Sageline 50 Accounts course, I got a second job using both this training and the previous course I completed, Excel Proficient. My training in Manual PAYE and Sage Payroll has enabled me to take over the wages responsibility in my other part-time bookkeeping job, and I have also set up a stock control system on the laptop using Excel spread sheets.There is also a possibility of taking on a further job working from home a couple of afternoons / evenings a week, doing the accounts for another local business using Sage on a laptop.
I am delighted with the “instant” results my training with yourselves have produced – the investment of time, money and effort was definitely worthwhile, now that I am reaping rewards well beyond my original expectations…. even at my time of life (over 50), retraining to specialist level in accounts has been an excellent decision.
THANK YOU!

DG – Accounting Technician Diploma

Book-Keeping, Private Individuals

Microsoft Access 2019 Expert