Microsoft Access Tutorial - My Holiday Home
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 https://communities.theiet.org/communities/files/31/13418
Show health and safety information
|Subject(s)||Computing, Data & Information|
|Tags||microsoft. access, information, Technology, Computing, database, tutorial|
|Age||11-14, 14-16, 16-19, FE/HE|
|Last updated||21 June 2017|
|Log in to rate this resource|