Access | Designing a database exercise | Create a Christmas list database
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
You can learn how to do this exercise on the relevant Wise Owl classroom training course (sadly for the moment only in the UK).
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Create a new database to hold your Christmas shopping list ideas, called Xmas list.
In this database, create and populate a table to hold the people for whom you are buying presents:
Here the PersonID field will be the primary key
Now create a table of all the places from which you typically buy presents - here is what it might look like:
Feel free to add your own favourites!
Create a third table which allows you to enter present ideas:
Hopefully your present ideas are more imaginative than this
Close down all of the tables that you have created, and enforce referential integrity for the relationships:
This is what your relationship diagram should look like
Close down your database!