Microsoft Access
Creating tables exercise
Average difficulty

This Microsoft Access CREATING TABLES exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl BASIC QUERYING IN ACCESS 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 Table of Pets

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

1)	Create a table to record each pet with the following fields: PetId (AutoNumber) - Key Field PetName (Text) Gender (Text) PetDOB (Date/Time) - Short Date Email (Hyperlink) PetColourId - use the lookup wizard to link to the PetColour table LikesToEatId - use the lookup wizard to link to the LikesToEat table PetTypeId - use the lookup wizard to link to the PetType table OwnerId - use the lookup wizard to link to the Owner table SpecialRequirements (Memo) VetBills (Currency)
2)	Edit the Gender field and set the following lookup properties, to make the Gender field a lookup (note that you can set these properties using the lookup wizard field type): Set the Display Control property to Combo Box Set the Row Source Type property to Value List Set the Row Source property to Boy;Girl
3)	Save the table with the name Pet.
4)	Enter some Pet records (you can make them up - or use pets that you have known!).
When entering/editing data in a Hyperlink field, press F2 on the keyboard.
5)	Close the table.

Thank you for showing an interest in this Basic Querying in Access 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