Sedang Disiapkan

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:

Breakfast

Oatmeal

Hard Boiled Eggs

Grapefruit

Orange Juice

Ham and cheese sandwich

Broccoli

Milk

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?

Kemahiran: Microsoft Access

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Brookfield, United States

ID Projek: #16706412

Dianugerahkan kepada:

jonathanpradas

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 Lagi

$250 USD dalam 5 hari
(44 Ulasan)
5.0

11 pekerja bebas membida secara purata $453 untuk pekerjaan ini

paris2785

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 Lagi

$400 USD dalam 7 hari
(89 Ulasan)
6.5
VladimirLilenko

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

$400 USD dalam 6 hari
(87 Ulasan)
5.9
workerbee1974

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 Lagi

$833 USD dalam 10 hari
(31 Ulasan)
6.1
alaeddindhahri

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 Lagi

$350 USD dalam 7 hari
(62 Ulasan)
5.6
zu02

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 Lagi

$750 USD dalam 10 hari
(44 Ulasan)
6.1
finecodervw

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 Lagi

$250 USD dalam 10 hari
(44 Ulasan)
5.5
royalcalif

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 Lagi

$250 USD dalam 10 hari
(54 Ulasan)
5.6
$555 USD dalam sehari
(5 Ulasan)
4.2
$388 USD dalam 10 hari
(0 Ulasan)
0.0
bnrajumnc

A proposal has not yet been provided

$555 USD dalam 15 hari
(0 Ulasan)
0.0