Microsoft Access
Designing a database exercise
Average difficulty

This Microsoft Access DESIGNING A DATABASE exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ACCESS INTRODUCTION FOR DEVELOPERS course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Create a Christmas list database

A full answer to this exercise is provided as part of the training course!

1)	Create a new database to hold your Christmas shopping list ideas, called Xmas list.
2)	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
3)	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 instead!
4)	Create a third table which allows you to enter present ideas:
	Please be more imaginative than this!
5)	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
6)	Close down your database!

Thank you for showing an interest in this Access Introduction for Developers training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.

Return to the list of exercises for this topic