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.
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.
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.
Microsoft Excel