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
No comments:
Post a Comment