How do I go about creating a recipe database in Access?

Answer by  sonicfoundation (2597)

First, you would need to create the database in Access and the fields you want to be in the recipes. Then all you have to do is add the ingredients.

Answer by  Blossom9283 (358)

Depending on what you are doing with the database a stating point would be: Database Recipe with three tables. Table Ingredients wold have: IngredientName as primary key, Amount, Measurement. Table Steps would have StepName as primary Key, StepDirections, IngredientName (The ingredient needed for the step). Table Together would have RecipeName, Temperature, StepName, CookTime, PrepTime. This can be adjusted as needed.

Answer by  rabbui (275)

You can download a template online and use that or create one from scratch. To create yourself, make tables to hold the recipe details with fields like name, origin, type, etc. You would then create a subtable to capture ingredients.