Our Access training courses are focused on ensuring that we make you a faster and more relaxed Microsoft Access user. Although Access can be intimidating initially, it is a very user friendly system once you are comfortable with how it works.
Our courses are carefully designed to give you lots of hands-on experience and get you using the system as much as possible. We give you lots of time practicing the concepts and ideas as we go through and explain them. This means that that you return to your office with practical, hands-on Access skills, not just a theoretical understanding.
A key strength of Microsoft Access is that it is a very flexible and configurable system. However, for the beginner this presents a challenge as it means that it has a very large number of menus and options, which can be confusing. By getting our delegates using the system we ensure that they leave comfortable with navigating the system and how it’s menus are structured.
Our main training centre is in Guildford. This is where we run our full schedule of Access courses. It is in the Surrey Technology Centre, very close to the Royal Surrey Hospital.
We also provide MS Access courses in London and Manchester centres, on request.
Our London centre is very close to Bank and Monument tube stations, and a short walk from Liverpool St and Cannon Street overland stations. Our Manchester centre is a short walk from both Oxford Road and Piccadilly stations.
We are also very happy to provide on-site Access training at your premises. This can be done on a date that suits you and customised to your requirements so that it only covers those topics most relevant to you.
MS Access is used extensively for data management and storage. It is widely used to track and manage company data so customers, contact details, order numbers and the like. It’s ability to hold, manage, present and summarise very large amounts of data quickly and simply mean that it is very widely used by smaller companies.
Access VBA allows experienced users to build customised systems which are optimised for their specific needs. VBA makes Access highly configurable so that it can be used to very quickly automate repetitive functions. A typical example of this would be generating and formatting monthly or weekly reports at the press of a button.
A simple example of this would be a system that stores customer company details and also contact details for individuals who work at the various customer companies. The system would typically have one table holding just the details of all of the companies that are customers, and another for all of the contacts at all of the customer companies.
Each customer company would have a unique identifier in the system so that each of the records for the individuals (in the contacts table) would be ‘tagged’ or ‘related’ to one of the companies in the companies table. In this way the data stored in separate tables is all related together.
MS Access is a relational database management system (RDMS). This means that it stores data in a series of tables (very similar to tabs in an Excel spreadsheet) which are all related to each other.
It is the database product contained within the Microsoft Office suite, Office 365 and Office for Mac. The improvements made in the most recent and most used versions of MS Access are described below:
Access 2016 is little different to Access 2013.
The biggest changes were the introduction of the “Tell me what you want to do” box )a much improved help section) and simplified data export to Excel.
It also contained look and feel improvements like shading the top menu a different shade to make it stand out more, the ability to select different themes and a larger show table dialogue to reduce scrolling.
Access 2013 was a faster and simpler to use than previous versions. The key improvements were to its ease of use customisation.
It contains a number of very useful templates which can make new database set up much quicker. These include a very good template for a CRM system. Something Access is frequently used for.
Other improvements were made to its apps functionality, autocomplete and moving to offer a standardised framework which makes navigation significantly easier.
The biggest change to this version to the user interface. It introduced the file tab to open a new area called ‘Backstage View’. This area contains the controls for executing operations across entire databases, and also displays a list of recently used databases.
Other significant changes were made to calculated table fields so fields whose values are derived from other fields in the same table were now allowed, and in conditional formatting, where the relative value of numeric cells can now be represented by a colour gradient.
This was the version of Access that introduced the ribbon interface. Although now well known and liked, initially many users struggled with these changes.
It didn’t contain any material changes to the software’s capabilities but did improved usability and speed by simplifying many repetitive tasks and making them more straight-forward.
For the advanced users it contained some improvements to macros.
Hear what previous attendees have had to say about this course
Have a question?
We're here to answer them
01483 688488Contact us