Microsoft Access is a database that was designed for single user use. That is ideally one person should use the database. Choose a training course ideal for you. Whether it's Live Online instructor led training you're looking for or the more traditional classroom based environment you are certain to find the right level and method that suits your training requirements.
Our Microsoft Access training courses will give you the confidence to create an MS Access database from scratch.
Our beginners training course gets you started, helping you to create a simple Access database. You will understand the different components of Access and how you use them to create a custom database. You will learn how to organise and manage your data by correctly utilising tables within Access. Understanding how to use queries to combine, find, filter and sort data will give you the ability to get the information you need from a series of database tables. Also employing Reports will enable you to display the data, gained from queries, in a clear manner. Moving on to Forms, you will create basic interfaces to make it easy for whoever uses your database to enter accurate information. Finally, you will see how configuring basic options in Microsoft Access will help you give your database that professional feel.
With our intermediate courses you will optimise your database skills building on what you have previously learnt. By understanding terms such as data validation and referential intergrity you will ensure the accuracy of your date. You will develop your forms and reports to make them more user friendly and interactive.
In the advanced course you will see how to use VBA to fully automate your database, making it a force to be reckoned with. Understanding how you can create a macro to program a user interface component and also understanding how to create a data macro.
Click on an Access training course below to see the specific course outline.
"I was very impressed. Simon has a great way of teaching which I found interesting and inclusive, he was very approachable, patient and helpful. Very knowledgeable. I would definitely like to be trained further on Excel by Simon."
Very informative and easy to understand, and Denise was relaxed, friendly and so helpful. After the course, I had a more clearer understanding and picked up tips and techniques I never knew.
"A fun learning experience coupled with excellent course delivery and content"
Live Online Excel Power BI "A very well delivered course. The trainer was very knowledgeable and was aware of the different levels of understanding. The pace was quick enough to deliver the course material and slow enough for everyone to keep up. Very informative course."