Closed

Database Designer Needed to make a custom Local Ms Access for a customizable food delivery company.

I am looking to automate and streamline a major part of my data keeping using Microsoft Access and Access VBA’s.

I own a meal delivery company where customer chooses ingredients and I need a Microsoft Access expert that can design database specific to my needs.

I currently use a CRM that provides an excel sheets of total orders weekly as well as seperate emails reports of an individual orders. These two will be the main forms of information in take

database design

In take:

Order Intake (automatically taking the information from the email, and constructing a customer profile such personal info, prefernce, delivery info)

Recipe Intake (Taking in data in multiple specific Categories on each recipe such as cost, calories, nutritional values, etc )

Inventory Intake (taking in data on the current inventory)

Order Generation

-To generate a list of all possible meal combos based on pre-defined menu restrictions.

-To generate a suggested weekly meal plan for each customer by selecting from all possible combos using filters such customers preferences, food cost, and calorie range.

-To add up the totals for all customers for each week, generate a total list, a prep list, purchase list and updated inventory, individual orders sheets

-to generate 2 sets of labels an excel output format

Here are the major aspects of my data processing

Order Intake

-customer personal information (name , address, contact info. Etc )

-Customer membership type ( small, medium, large)

-Customer preferences (as selected from the list)

-Customer comments/notes

Recipe Intake

-Nutritioonal information ( calories, protein, fat, carbohydrates, ….)

-food cost

-food prep instruction

-Recipe scaling

Individual Order Generation

-to generate a 4 week meal plan based on a customer specific query of data (all possible combos)

Total Order generation

-To generate weekly totals for orders

-to generate shopping and prep list based on the orders

Details

The program allows for filtering of combinations based on user-defined limits for each of these values.

-In practice, the program is meant to generate a 4 week meal plan for individuals by selecting from a excel sheets of all possible meals based on the customers preferred selection of ingredients and their preferred range of nutritional values.

This program also will be able to generates a weekly prep and shopping list that will be scalable.

-The user next will define a preferred range for each of these values (Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium)

Based on these restrictions the program will generate an excel sheet of all possible meal combinations.

This excel sheet will display two main sets of information section for each combination meal

• One displaying the actual combinations that visually make the meal Meat+ Vegetable+ Carbohydrate + Sauce + Spice + Garnish

• One displaying the combined nutritional value such as Total Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium

Skills: Data Processing, Database Development, Database Programming, Excel VBA, Microsoft Access

See more: route4me free download, order form online, online food ordering system project report ppt, delivery route optimization software, best route optimization software, free order form template, online food ordering system documentation pdf, routing software for small business, access 2007 template delivery company, access database programmer needed urgently, access ms access database manually, attendance ms access database, backup restore ms access database vb net windows application, cheap ms access database design, code store text form vb project ms access database, connect google map ms access database vb, convert exe files database ms access, convert ms access database exe, convert ms access database program, convert ms access database standalone software

About the Employer:
( 3 reviews ) Port Coquitlam, Canada

Project ID: #18613567

17 freelancers are bidding on average $280 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without c More

$250 CAD in 4 days
(189 Reviews)
7.5
Prashantskin

[login to view URL] I have gone through your project requirements.I will do the complicated access application as per your description regarding the Food delivery system I will develop it within 5 days only My ratings and re More

$277 CAD in 5 days
(482 Reviews)
7.2
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 More

$500 CAD in 5 days
(129 Reviews)
6.3
royalcalif

Already we had discussed about the project. please pm me. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know t More

$30 CAD in 1 day
(87 Reviews)
6.0
fanninson45

SHOWCASE I have done a similar Access projects before with 5* ratings: https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ https://www.freelancer.com/projects/database More

$200 CAD in 3 days
(21 Reviews)
5.9
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 More

$250 CAD in 5 days
(73 Reviews)
5.8
VBAautomation

Hi, Hope you are doing well.  Thank you for giving me the opportunity to express my interest on your project. Please have a look at my profile and portfolio, I have all those skills to complete your project. I am More

$200 CAD in 3 days
(28 Reviews)
5.2
tiaratechies

Hello, being MS office experienced person I can complete the task either in access or excel using VB if you are interested drop a message.

$700 CAD in 3 days
(18 Reviews)
5.0
rayyankabir

Hi there, Greetings! I am an experienced MS Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, Excel, and other Office appl More

$250 CAD in 5 days
(16 Reviews)
4.7
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you More

$233 CAD in 4 days
(20 Reviews)
4.7
cyash61

Hey there, I am analytics consultant with experience of more than 6 years working for highly prominent companies across the globe. I have delivered more than 50 projects in Data processing and Statistical analysis fie More

$277 CAD in 3 days
(4 Reviews)
3.6
alhassanlatif

Hi, I am a professional Access developer I have done many projects in Access have a look at my profile. I have a very good command over SQL and user interface desgin.

$166 CAD in 3 days
(5 Reviews)
3.4
tsft

Dear Sir or Madam: I am interested in doing the job. I would like to chat for more details: INPUTS OUPUTS. I wait for your contract. Kind regards. Remote Work Guidelines of my Software Factory -Onlin More

$250 CAD in 20 days
(4 Reviews)
2.2
martinchege324

Greetings, I am an experienced database developer interested in your project. I have over 5 years of experience in Access VBA and would be the ideal expert to handle your project. I can successfully integrate the ex More

$150 CAD in 5 days
(0 Reviews)
0.0
LeapReality

Hello. I would love to take on your project. I have 4 years of experience in working with MS Access (VBA) creating databases that import data in order to store, manage, and report data. While, some may just design a da More

$666 CAD in 25 days
(0 Reviews)
0.0
xxyang9

Hello, I can deliver your project and provide ongoing support and maintenance. I have 8+ years of professional experience as Access Database Developer. Have been principle database developer in 6+ projects that involv More

$277 CAD in 7 days
(0 Reviews)
0.0
virendrastarone

databse designer to be needed o make local ms acess for a curomizato food dielver y company High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job po More

$86 CAD in 3 days
(0 Reviews)
0.0