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:

Access 2010 exercise - Designing a database (image 1)

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:

Access 2010 exercise - Designing a database (image 2)

Feel free to add your own favourites!

Create a third table which allows you to enter present ideas:

Access 2010 exercise - Designing a database (image 3)

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:

Access 2010 exercise - Designing a database (image 4)

This is what your relationship diagram should look like

Close down your database!

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post