IT406 - Ereating Tables

1. Open MS Access 2003
2. Name your new database to Recipes
3. Create tables using the following fields

Field Name /Data Type

AreaID /Number
AreaName/ Text

Save your table under the name of : Area

4. Add the data as shown in the diagram below.




5. After entering all the data, save and close your Area table
6. Create Another table name: Recipe


Field Name /Data Type

RecipeID/ Number
RecipeName/ Text

Save your table under the name of : Recipe

7. Add the data as shown in the diagram below.







8. After entering all the data, save and close Recipe table
9. Create Another table name: Ingredients

Field Name/ Data Type

IngredientsID /Number
IngredientsName/ Text
AreaID /Number
RecipeID /Number
Quantity /Number

Save your table under the name of : Ingredients