Microsoft Access Tutorial - My Holiday Home

Rate this resource

This tutorial provides detailed instructions on creating a Microsoft Access database using an example that manages the lettings of a holiday villa in France or Spain.

It will provide students and teachers with an in-depth understanding of MS Access and an ability to design and construct their own databases to benefit themselves and their employers.

Each stage is detailed in minute detail to guide the student through to a completed database.

The tutorial starts with the example database and then goes through creating the database, adding Tables for customer Names and Bookings.

Then Queries to enable us to combine tables and sort into sequence. Data is added to the tables and queries so that we can see the data on subsequent forms.

We then create Forms into which we can input or change the data, including an opening Menu which is displayed using an opening Macro.

The tutorial continues by explaining the IIF function and others and utilises these to create a diary with the bookings shown in a weekly timetable. We also cover the design of a printout.

Students can proceed at their own pace but the typical minimum time for the entire tutorial is of the order of six to eight hours, however some can be completed as "homework".

The tutorial requires downloading Microsoft Access 2013 or later versions.

Please download the full set of visual aids and the database from​ ​

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Published by


Share this resource

Lists that tag this content