Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
395 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
| Software ==> | Access (66 exercises) |
| Topic ==> | Designing a database (3 exercises) |
| Level ==> | Average difficulty |
| Subject ==> | Access training |
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.
Create a new database called Recipes.
Create a new table to hold the different supermarket areas from which you can buy ingredients. When you have defined the fields, enter data as shown below:

Your table should contain two fields, as shown above
Close this table down, then create another table called Recipe to hold your favourite recipes (if you haven't got any, make them up!). Here is what this might look like:

Here we will add the ingredients for two recipes, but feel free to choose different ones
Finally, create and populate a table to hold the ingredients that you need to buy - this might look like this:

Note that in this case Quantity will be a text field
Apply referential integrity to your relationships:

This is what the final diagram should look like
Close your database down when you have finished.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2026. All Rights Reserved.