Chef's Kitchen Helper. Using Microsoft Access to Determine Possible Meals Based on Available Stock.

This video will show you how to use a query to determine what dishes you can make based on the available ingredients. Not limited to just the kitchen. You can use this to calculate needed components for any product that involves multiple parts. Whether you're selling food, computers, or machine shop parts, these techniques work for everyone.

Camila from Milan, Italy (a Platinum Member) asks: I run a small kitchen. I would like to have a database that includes a list of all of the recipes for the dishes that I make including the ingredients, the amounts required, and the amount I have on hand. I would like to be able to quickly see what dishes I can prepare based on the ingredients I currently have in my pantry. Is this possible?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to look at the actual quantity of the products you have on the shelf and calculate if you have enough to make a dish. Instead of just "yes, I have eggs" you can say "I have 12 eggs" and calculate accordingly.

MEMBERS ONLY VIDEO:
   • Chef's Kitchen Helper. MEMBERS ONLY E...  

BECOME A MEMBER:
   / @599cd  

LINKS:
Get on my Mailing List: https://599cd.com/YTML
Relationships: https://599cd.com/relationships
Aggregate Queries: https://599cd.com/aggregate
IIF Function: https://599cd.com/iif
Access Developer 19: https://599cd.com/acd19

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
FREE Blank Customer Template: https://599cd.com/FRL2
$1 Access Level 2: https://599cd.com/1Dollar
TechHelp: https://599cd.com/TechHelp
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, components, inventory, pantry, chef, kitchen, products, parts, pieces, multiple, restaurant, stock control, retail

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.