In Progress

Meal Planner and Shopping list Access DB

I am trying to build a meal planner and shopping list. At its heart, it is a tool to tell us how much of something to buy based on data we provide about what we will use.

The final product tells us how much of every consumable is needed for a certain period of time, either one or two weeks, based on our input. We collect this info by filling out a daily meal plan. That meal plan is made up of items, for example, mashed potatoes. Each item has a recipe that is made up of the info on the build list.

For example, mashed potatoes uses 4 lbs of potatoes, 2 cups milk, 4 tbsp butter. If we have mashed potatoes 4 times in the two week period, the shopping list will indicate we need 16 lbs of potatoes, 8 C Milk, 16 T butter.

We will fill in all the data, we just need to have the relationships established. I will enter mashed potatoes in the meal list. That will pull data from mashed potatoes in the item list, and the recipe for mashed potatoes in the recipes list (which I will create in the template you provide). The resulting data will go into the shopping

A daily meal plan might look like this:



Hard Boiled Eggs


Orange Juice

Ham and cheese sandwich



Baked Chicken Thighs

Mashed Potatoes

Green Salad

The recipes would be like this

Oatmeal : 1.5 C oatmeal, 1 C milk

Hard Boiled eggs: 6 eggs

Grapefruit: 3 Grapefruit

Ham and cheese sandwich: 12 slices bread, 4 ounces ham, 6 slices cheese, 1 tomato, 1/4 head lettuce

Broccoli: 1.5 heads broccoli

Milk: 4 C Milk

Baked Chicken Thighs: 6 chicken thighs, 2 eggs, 2 C breadcrumbs

Mashed Potatoes: 4 lbs potatoes, 2 C milk, 4 T butter

Green Salad: 1 head lettuce, 1 green pepper, 1 red onion, 1 tomato

Based on this we would need the following:

1.5 cups of oatmeal

8 eggs

5 cups of OJ

3 Grapefruit

12 pieces of bread

4 ounces of ham

6 Slices Cheese

6 chicken thighs

2 cups bread crumbs

4lbs of potatoes

8 cups milk, (5 for lunch, 2 with mashed potatoes, 1 for oatmeal)

4 T butter

1.25 Head Lettuce

1.5 Heads Broccoli

2 tomato (1 for ham and cheese, 1 for Salad)

1 red onion

1 Green Pepper

All of this would prefill in the shopping list because we would have entered all the recipes. It would be cumulative for all the days. So if we have 7 days of plans, the spreadsheet would add up all the ingredients from each day and give me a [url removed, login to view] resulting report would tell us, based on the meal plan, what we need to buy for the next week.

This would of course be integrated with some kind of weekly calendar, so we can fill in breakfast, lunch and dinner for each day, as well as giving us the ability to print the daily meal list, ingredients list for each item, and shopping list.

I think this would be best in Access DB because of the reports we could print, and the recipe integration, but I am open to other ideas. What do you think?

Skills: Microsoft Access

See more: best wordpress plugin meal planner grocery list, shopping list meal menu database access, access meal planner shopping, shopping list meal planner access database, meal planner database access, meal planner access, access database meal planner, access meal planner, access dinner meal planner, meal planner access database, access database shopping list, access meal planner database, asp planner shows list bookings apartmentsreads access db, shopping sample access, upc reader shopping list

About the Employer:
( 0 reviews ) Brookfield, United States

Project ID: #16706412

Awarded to:


Good day. The time frame and the bid amount are just for the preliminaries and are still subject to change depending on our negotiation. I will suggest to use MS Access for this one since what you described is feasible More

$250 USD in 5 days
(44 Reviews)

11 freelancers are bidding on average $453 for this job


Hi, there. My name's Paris Pallas and I'm a very experienced Access developer. Feel free to visit my portfolio to get an idea of my work quality. I read your brief and I'm confident I can help you with creating a More

$400 USD in 7 days
(89 Reviews)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl More

$400 USD in 6 days
(87 Reviews)

My passion is building Custom Access Databases. I have built well over 300 custom databases in the past 19 years. I have taken all classes from beginner to expert 97 to 2013. I can send working samples on request. Som More

$833 USD in 10 days
(31 Reviews)

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel More

$350 USD in 7 days
(62 Reviews)

p.s. I think Ms Access is a best fit for your current project Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for More

$750 USD in 10 days
(44 Reviews)

Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013,2016 projects both big and small using MS Access as a front end as well as back More

$250 USD in 10 days
(44 Reviews)

We can develop this application in MS access. Pm me for more information and sample as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report t More

$250 USD in 10 days
(54 Reviews)
$555 USD in 1 day
(5 Reviews)
$388 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$555 USD in 15 days
(0 Reviews)