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

Imefungwa Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

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

Kutengeneza Data Ujenzi wa Database Kuprogramu Database Excel VBA Microsoft Access

Kitambulisho cha Mradi: #18613567

Kuhusu mradi

16 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

16 wafanyakazi huru wanazabuni wastani wa $256 kwa kazi hii

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 Zaidi

$250 CAD kwa siku 4
(Maoni 266)
7.9
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 Zaidi

$500 CAD kwa siku 5
(Maoni 206)
6.9
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 kwa siku 3
(Maoni 31)
6.1
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 Zaidi

$200 CAD kwa siku 3
(Maoni 28)
6.2
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 Zaidi

$250 CAD kwa siku 5
(Maoni 73)
5.9
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 Zaidi

$200 CAD kwa siku 3
(Maoni 35)
5.6
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 Zaidi

$250 CAD kwa siku 5
(Maoni 20)
4.9
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 Zaidi

$233 CAD kwa siku 4
(Maoni 20)
4.7
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 kwa siku 3
(Maoni 6)
3.7
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 Zaidi

$86 CAD kwa siku 3
(Maoni 1)
2.9
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 Zaidi

$250 CAD kwa siku 20
(Maoni 4)
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 Zaidi

$150 CAD kwa siku 5
(Maoni 0)
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 Zaidi

$277 CAD kwa siku 7
(Maoni 0)
0.0