I require an access database that enables me to enter all meals required for a weekly period. With the ability to save this information in order to retrieve. The objective is to produce a shopping list from the meals, a menu planner to print out and a couple of other useful reports noted below.
From the weekly meals selected the following reports need to be produced;
Shopping List – by shop and in specific order (not alphabetical)
List by ingredients – showing what recipes ingredients are used in
List of important ingredients – showing when used over the week
All Ingredient and Item List – a general list of all items per shop in order to mark on manually
Weekly Menu Planner – showing each recipe, with book and page number and prep notes back 1, 2 or 3 days - on one A4 page
Data to capture
Ingredients: Name, Shop to purchase, Important or not (for reporting), Ingredient Type (for sorting), Unit of measurement
Units of measurements: Need to consider that an ingredient may be purchased in a different unit of measure than used in recipe – how can this be shown on the shopping list? Might have ingredient listed twice, with different units of measurement?
Recipe Books: Book Name, Author
Recipes: Name, Description, Recipe Book, Page Number, Prep on day, Prep 1 day before, Prep 2 days before, Prep 3 days before, Meal rating, Ability to add a photo, Meal Type (Breakfast, Lunch, Dinner – could be all), Selected items and quantity required
General Shopping List – for non food/recipe items
I would like to us MS Access, as this is for home based used. I also require full access to edit reports, forms and view the data too. Design does not have to be too fancy – the functionality is more important.
I have a database designed – however the integrity of the shopping list is not sound. It can't be relied upon. Given this is basically the reason for this request, the shopping list must be right. Also I do not have the ability to edit the database or reports.
I look forward to hearing proposals and quotes.
23 freelancers are bidding on average $369 for this job
I have 9 years of experience and have completed 136 projects world-wide with 10 on 10 rating. I can start ASAP so lets discuss in INBOX,PMB in details. - Regards : TUHIN