recipe file database help to start

[JohnnyS]

new to access.


not sure where/how to start.
my goal is to build a database for my recipes for my computer. ultimately a cd and "maybe" a user friendly website one day.

im not sure what to call it, but a Graphic User Interface(GUI) for a search box with an output display of desired recipe

i am using access 2016 on WIN 10 OS. so far the tutorials I've seen are in older versions of access so it makes it hard to follow.

thank you for any help

[rpeare]

I haven't used access 2016 so I'm not sure what you mean by an 'old' version of access.

But your table structure would look something like

tblIngredient
I_ID  I_Name  ---> other ingredient fields like seasonal availability, etc.
1     Nutmeg
2     Sugar
3     Cinnamon
4     Ground Cloves
5     Baking Soda

tblMeasures
M_ID  M_Name 
1     Teaspoon
2     Cup
3     Tablespoon

tblRecipe
R_ID  R_Name       R_Desc
1     Pumpkin Pie  My awesome pumpkin pie recipe
2     Apple Pie    Vague description of recipe

tblRecipeIngredient
RI_ID  R_ID  I_ID  RI_Measure
1      1     1     1/2 TSP
2      1     3     1/4 TSP
3      1     4     1/2 TSP

then probably a separate table for the mixing/cooking instructions

[JohnnyS]

I haven't used access 2016 so I'm not sure what you mean by an 'old' version of access.

thanks for the reply rpeare, but i dunno what to do with this. i was hoping something like a video or a link to a video on the same interface that will get me in the direction of my goal.
i loved XP too, i miss it. but i recently died on me which bumped me up into WIN10.

[ssanfu]

Start by WORKING through these tutorials http://www.rogersaccesslibrary.com/forum/forum46.html

Learn about normalization and Entity-Relationship Diagramming.

[rpeare]

'this' is the basic table structure. That won't change with your version of access, it's simply a way to normalize your data structure. It would be your starting point to build your user interface around. If you have no idea how to build a GUI that's a different question. Your original post was pretty generic so my response was pretty generic too

[JohnnyS]

im sorry i was not clearer. i am brand new to both access and win 10. so i am like a fish out of water. coming from an XP OS myself i am struggling to find everything. so let me start over and try this explanation.

i am in need of a database to store my recipes.
i am thinkin i need 4 tables. no, 5.

name
category(appetizer, entre, side, dessert, etc...)
ingredients
cooking directions
image

question. if i add allcipesnames to an excel sheet so i can alphabetize them. will that copy/paste easily into an access table for the names?

1. idealy it will be searchable by full or partial recipe name(Rec_Name) or ID
2. can i have an output display such as this image?


this is the template i have been using on my website. so it is desirable to keep it uniform




by the way rpeare, i do appreciate your help. unfortunately i didnt know what to do with the code you gave me. so i should start with 4 tables like you outlined? please forgive me if i came of rude

[JohnnyS]

thanks steve. i will get started on these tutes