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.
"Simon makes the training an easier task by approaching his public first, in order to know their level of knowledge, and then he presents the BI functions in an understandable and patient way. Excellent introduction for beginners and an overview of the amazing tools Power BI provides for creating reports, data analysis and decision making."
"I had previously finished a similar course and felt that I hadn't learnt enough from it, this course however was perfect and I now feel much more confident to work on Power BI. The course was run extremely well via Zoom with details being given if we asked for in depth on certain areas but usually the trainer explained everything so clearly there was little need for more questions. I am looking forward to the next level of training on it now as well."
"Incredibly useful training, have been able to learn and practice a whole new set of formulas that will be incredibly helpful at work."
"Very efficient Very clear and easy to understand Simon was very accommodating in showing us functions outside the day course Easy to follow instructions Lovely lunch and snacks. Simon and Cindy are really pleasant and lovely people, I left with the feeling that I had learnt a lot Mission accomplished!"