Microsoft Access

Access is a relational database management tool that allows information to be stored in tables that are related to one another. Instead of managing data manually a database can be set up in Access allowing information to be organised, retrieved and analysed quickly and effectively.

We have two standard courses acvailable as public courses – Introduction & Intermediate. Advanced courses can also be arranged (VBA) should this be a requirement. Please see the course options listed below.

We can also create a customised course outline to address any specific requirements you might have – please contact us for more information.

Microsoft Access Stage One (Introduction)

This course is suitable for anyone new to Microsoft Access and also for those who may currently use a Microsoft Access Database from time to time but have a limited working knowledge of the application. Over one day, we will create a single table MS Access database, enter & edit data both directly in the table and through the use of forms.

We will then manipulate records within the Data Sheet and form and progress to creating and saving and running queries. Finally we will also look at how to create reports in order to produce the extracted required in the most professional format. On completion of this course, it is recommended that you also complete the MS Access Stage Two programme as in Stage Two we will cover multiple table databases creating relationships between the tables to fully harness the power of Access.

Please click on the link below to download the full course outline.

Download PDF

Microsoft Access Stage Two (Intermediate)

It is essential that users have attended or are completely familiar with all of the Access Level One topics prior to attending the Level Two course. We will build on the topics covered on Level One and really start to understand the use and power of Access by creating a multiple table database and building relationships between tables. We all also look at some of the more advanced field and table properties and further manipulate data through writing calculations in tables and forms.

We will also look at collaborating with other MS Office applications – exporting data to MS Excel and merge records with letters, labels etc. in MS Word.