This advanced Microsoft Access training course will build on your existing skills to teach you how to make the most of Access’s advanced functions.
It is a hands-on course. It includes plenty of time for experimenting with what you are being taught, trying things out for yourself and asking questions.
By the time you finish, you’ll have a thorough understanding of all of Access’s advanced functionality.
✔ A complete advanced Access course.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.
This course covers the more complex features in Access. You’ll learn how to:
Good working knowledge of Access is required before you attend this course.
You should have an understanding of concepts covered in our Access Introduction/Intermediate course. These include creating and modifying table structures, creating a relational database, working with records, creating queries, forms and reports.
Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch.
We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour A4 manual covering everything in the course for you to keep.
✔ A USB stick so that you can take the course exercises home with you and practise in your own time.
✔ A Certificate of Attendance.
This introductory session is a quick revision of all of the key concepts around importing and exporting data from Access databases to Excel and text files. We also cover using Access to interface with an external data source.
The key concepts trained in this session include:
This section covers more advanced queries. It starts with covering aggregation queries. These queries do not present each item of information but the aggregation of this. For example, if you would like to know your total sales for the last month that would be an aggregation query as it would calculate all sales for last month and then aggregate them.
This session coves aggregation queries in detail. It covers working with simple and multiple aggregations, for simple and calculated fields. It then moves to look at using queries to modify your data and also look at working with expressions in queries.
The key topics trained include:
Forms are an essential way to make databases accessible to non-users by controlling and managing their access to the underlying tables.
The key skills that are trained include:
As with all Microsoft Office products, MS Access allows you to record macros to automate repetitive tasks. This session covers the basics of Access macros. So creating, saving, editing and running a macro.
For experienced macro users in Excel or Word, this will be relatively familiar. For people who are not experienced macro users, this can be an eye-opener when they learn how simple it can be to automate tasks in an Office program.
The key skills trained in this session are:
To attend this Access course online, you will need:
✔ MS Access on your Windows PC/laptop with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom to attend the course
If you have access to a second screen, we would encourage you to use it as it improves the experience.