Closed

Menu Planner Database

This project received 25 bids from talented freelancers with an average bid price of $372 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
25
Project Description

Requirements
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.

Reporting
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?

Shop: Name

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

Database
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.

Previously
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.

Thank you

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online