Microsoft Access is flexible, powerful, and easy to use – if you know how it works! And if you do, it will make a huge difference to how you use and present your data.
Some of the screens resemble those in Microsoft Excel, but the ability to create reports, forms and query results takes you to a whole new level.
Our Microsoft Access training courses take you through from the basics to high-performance, automated applications. So whether you have no experience, or you're an advanced user wanting a refresher, these courses will give you the training you want.
We run two sets of courses, from Introduction (beginner) to Advanced levels:
Our MS Access 365/2021 courses include, practically speaking, all the features and functionalities currently available only in the subscription-based Excel 365. They are also extremely detailed, with each course giving you around 7 hours of interactive study.
Our MS Access 2013/2016 courses are a great alternative, giving a lower-cost option (few of the basics have changed) for anyone looking for a speedy "crash course", and also for people who are using older versions of the software.
All our courses teach you the "right" way, using best practice and avoiding common pitfalls. By enhancing your database skills, you will expand what you can do, improve the quality of your work -- and boost your productivity too!
The CPD mark of approval means that not only have our courses been rigorously assessed in terms of content and quality, but there are options for you to get a CPD Certification certificate to keep.
Our Microsoft Access Introduction course shows you how to set up solid and functional databases from scratch.
We begin with where to start, whether to use a template or not, and how to modify Access to suit your needs.
Then, we show you how tables work in Access and how to create relationships between them.
Next, you'll learn about creating forms and sub-forms, how to run queries and print from Access.
We also show you how to start to use macros, the basics of the Access web app, and how to export and report in Access.
With all this under your belt, your work in Access will be solid, reliable and easily accomplished. You won't look back!
Once you're using Access to create databases, you'll want to improve your skills.
This course assumes you know the basics of Access: how to set up your database, how tables work, how to create forms and run simple queries.
We start by covering Primary Keys and Indexes in Access, and we show you how to customize and filter in the Datasheet View.
We then show you how to link to other databases, how to use ODBC and SQL Server, and how to split an Access database into front and back-end.
Next, you'll move into using Macros in Access, including AutoExec, before learning about basic VBA in Access including code and error handling.
The course finishes with advanced techniques for creating forms in Access, and advanced queries including "multiple where" criteria.
After this course, you'll be a true Microsoft Access power user!
Microsoft Access is a powerful application which needs careful setting up. So learning the basics in a structured way is essential.
You start by learning how to get started, use the Access interface and create a simple database that contains your data.
You then move on to simple Forms, Queries, Reports and Filters which enable you to analyse and display your data.
You will now have a solid basis for understanding and using Access to create solid and reliable databases.
If the Introduction course showed you how to set up the basics, the Intermediate course shows you how to work at a higher level.
You learn about Database Management and working with, saving, exporting, and linking, files.
You then move on to Table properties and data validation; formatting and controlling your Forms, and working effectively with Reports and Queries.
The skills you acquire in this course will enable you to set up commercial-standard databases with a whole host of practical uses.
The Advanced course takes you to a level that will leave behind other office users of Access.
You'll learn about advanced data management, working with forms and automating reports at the highest level.
We'll introduce you to SQL, and take you to advanced queries, sub queries and joins, before covering macros, procedures and VBA.
If that sounds a little daunting, remember that because of the modular nature of our courses, you can choose what you want to learn, and cover them one at a time.
If you are involved with processing and displaying data, there comes a time when spreadsheets aren't enough.
Step in Microsoft Access, and our courses show you how to master this powerful application.
You will learn how to set up Tables, Forms, Queries and Reports, how to link them to simplify the processing of huge amounts of data, and even to enhance your applications further using Macros and VBA.
You have total flexibility ... you can work through all the course content so you have a thorough knowledge from start to finish. Or treat the content as your "library" - to refer to and learn as you need.
Either way, you'l find all our courses easy to watch and available 24/7 to upgrade your Microsoft Access skills.
POWER pack: Microsoft Access Introduction, Intermediate & Advanced
You do not require any experience of using Access, but you will need to be familiar with using a PC with Microsoft Windows, and some experience with Microsoft Excel will be useful.