Database Designer Needed to make a custom Local Ms Access for a customizable food delivery company.
$30-250 CAD
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
Kitambulisho cha Mradi: #18613567
Kuhusu mradi
16 wafanyakazi huru wanazabuni wastani wa $256 kwa kazi hii
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
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
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.
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
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
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
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
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
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.
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
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