I am new to Access, taking a class for school, and am having a hard time designing my tables so that they have a reasonable amount of fields. It feels like I either have too many or only two, including the ID.
I am trying to design a database that will allow me to find recipes from cook books based on what I have in my kitchen, instead of finding a recipe and hoping I have all the ingredients. I guess what I'm asking is if anyone might be able to offer some advice on what I should keep in mind when building my tables and creating relationships; do I really have to put each ingredient and measurement in a separate table and create junction tables between all of them?