EXERCISE TOPIC▼
ACCESS EXERCISES▼
ACCESS EXERCISES▼
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.
| Software ==> | Access (66 exercises) |
| Version ==> | Access 2010 and later |
| Topic ==> | Designing a database (3 exercises) |
| Level ==> | Average difficulty |
| Subject ==> | Access training |
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!