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.
"Alan was amazing thank you so much!!!!! Never thought I would find Excel interesting but here we are, it is actually a bit addictive.... We will be on the advanced course soon hopefully!! Please pass on our thanks and regards he was absolutely fantastic."
"The training session was very helpful. It was great to gain a better understanding of the other apps available on One Drive. Simon broke down everything into bitesize information and made it very easy to understand. Thank you"
"The course was very informative and interesting, this is the first time I have used this programme and enjoyed the learning. The tutor was very clear and patient. The training came at the right time as I will be able to use this with the new Recruitment Process Mapping etc that is due for updating."
"Extremely informative especially on Pivot tbls & VLookup I have come away with an expanded knowledge of Excel, which in turn brings a huge degree of confidence back into my reporting"