This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I need to track menu items and allergies. Would it be better to do this in an Excel Spreadsheet or an Access Database? I want to be able to enter ingredients for every item on a menu and then run a list of items that are appropriate for someone with a given allergy. For example if someone can’t have wheat or soy I want to be able to identify the foods from the menu that the person can consume. I have about 100 different allergy combinations and probably 200 menu items.
Would need to be able to update ingredient information and add new products as those changes occur.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This project falls squarely in the realm of database applications. That means you need to learn how to create a proper relational database using Access.
Yes, sorry I meant an Access database.
You mean Excel or MS Access?
With those data combinations then I would be looking at Access