Microsoft Access 2019 Expert

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.

Microsoft Access 2019 Expert

Your details

Training Centre

Hidden
Hidden
Hidden
Hidden
Hidden
Hidden

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

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.

Executive PA – 2-day workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This 2-day workshop is ideal for any PA looking to increase the contribution they make to their organisation. It is also aimed at secretaries who wish to develop and move up to the role of a PA. What you will learn: To understand the role of the Executive PA To learn to communicate effectively at...

Event Series Power BI Introduction

Power BI Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. What you will learn Get to know the Microsoft Power...

Identify and Manage Stress

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This course is designed to understand what stress is, where it comes from and how it can affect you and those around you. As well as what you can do about it. What you will learn: Understand what stress means to you and how your body reacts to stress. Identify your own pressure and stress...

Event Series Telephone Techniques

Telephone Techniques

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important part of their job role. What you will learn: Improved communication skills The importance of voice and attitude Listening skills and questioning techniques. To sound...

Train the Trainer – 3- day workshop

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

  CPD Accredited  Tutor led training, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. Can be delivered via virtual classrooms or onsite at your workplace. Aim: This course will introduce participants to the issues, methodologies and techniques of training design and delivery. Objectives: By the end of this workshop, participants...

Adobe Illustrator

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom +2 more

IT and Adobe Training Workshops AVAILABLE IN GLASGOW & EDINBURGH ON DEMAND - PLEASE CONTACT US FOR MORE DETAILS Adobe Illustrator For Individuals who are new to illustrator or have only used Illustrator for limited tasks. During the course you will learn the fundamentals of Adobe Illustrator Creative Cloud from our certified Adobe Instructor. Classes...

Event Series Excel Introduction

Excel Introduction

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For individuals who have never used spreadsheets or the Excel application before or only used Excel for limited tasks. At the end of the day, you will be able to create professional-looking spreadsheets. What you will learn: An Introduction to Excel - the ribbon bar, enter move and clear data, saving in Excel, creating new...

Train the Trainer – 3- day workshop

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

  CPD Accredited  Tutor led training, delivered in person – available on our schedule timetables in Edinburgh and Glasgow. Can be delivered via virtual classrooms or onsite at your workplace. Aim: This course will introduce participants to the issues, methodologies and techniques of training design and delivery. Objectives: By the end of this workshop, participants...

Event Series Excel Intermediate

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...

Event Series Leadership Skills

Leadership Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For managers who are developing into senior leaders. You are even less involved in the day-to-day delivery of the work; your success depends on your ability to manage your managers as well as mentor and inspire others. Your people skills need more finesse because there is more at stake; your emotional intelligence comes to the...

Supervisory Skills – 2- day workshop

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This course is designed for new supervisors/team leaders/managers or those in these roles who have not received any formal supervisory skills training. The aim of this 2-day workshop is to provide participants with a range of skills, methodologies, and techniques to enhance their ability to supervise people, tasks and change effectively. What you will learn:...

Event Series Excel Advanced

Excel Advanced

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. What you will learn: Macros – Editing and deleting macros, recording macros, customizing ribbon. Review Data...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

2 events,

1 event,

2 events,

0 events,

0 events,

0 events,

0 events,

3 events,

Adobe Photoshop

Event Series

2 events,

2 events,

0 events,

0 events,

0 events,

1 event,

2 events,

2 events,

2 events,

1 event,

0 events,

0 events,

0 events,

2 events,

2 events,

1 event,

0 events,

0 events,

0 events,

0 events,

4 events,

Adobe Illustrator

Event Series

1 event,

0 events,

0 events,