Database Designer Needed to make a custom Local Ms Access for a customizable food delivery company.
$30-250 CAD
Đã đóng
Đã đăng vào khoảng 5 năm trước
$30-250 CAD
Thanh toán khi bàn giao
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
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 changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Processing, Database Development, Database Programming, Excel VBA, Microsoft Access. Please ping me for more discussion.
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 possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
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-programming/Convert-data-Word-table-Access/
https://www.freelancer.com/projects/database-programming/data-base-search-options/
I can also produce a sketched prototype for this project and upload on YouTube.
INTRODUCTION
An experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products.
RECENTLY COMPLETED PROJECTS
• Customer Desktop Database Management
• Caspio Developer
• Access Database Search Options
• Convert data in a Word table to an Access database
• Import and Update Telecom Marketing Database with Access DB.
• Access Forms and Queries Integration
• SQL SERVER QUERY
• HUMAN RESOURCES DATABASE CREATION
• SQL Server OPtimization and Fix error Msg 824.
• Database Log Shipping Project to a Remote Server
EDUCATION
• BSc Computer Sciences, University of Hertfordshire, UK 2014
• Microsoft Certified Business Intelligence Developer 2009.
• Microsoft Certified SQL Server Administrator 2008.
• compTIA A+ Certified 2008.
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 develop this app. However, I'd like more details about the project.
Check my profile for previous clients' reviews and projects.
PS: please note that you added Excel VBA and Data processing in your project skills, this will flood your project with unreliable bidders who come from Excel Data Entry background.
Looking forwards to hearing from you.
Best,
Alaeddin
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 a professional MS Access/Excel and SQL database developer with 8 years of corporate experience. I can provide you best support. I have done lots of MS Access projects during my carrier. If you want I can show you some of my completed projects live.
I think you placed the same project few days back may be you couldn't find someone really good in MS Access. Give me this opportunity and see my performance.
Thank you
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 applications. Please ping me so that I can send you a few of my work.
I understood your basic requirement, let's discuss this on the detail level.
Thanks,
Rayyan
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.
with thanks and regards
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 post and I can understand your job requirement thoroughly.
I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job.
I have strong command over:
* WordPress, PHP, Wordpress themeing, Plugin Development
* Android and IOS all kind of mobile apps development
*Responsive theme Design
* HTML5, CSS3 , Jquery, Bootsrtap, Git,
* Widget Development
* Other CMS: Magento, Joomla, Expression Engine, Drupal etc.
* I’m honest & trustworthy, dependable & fast learner.
* I’ve over 7 years experience in Wordpress Website designing/development.
* I am available 40 hours a week for your job.
You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon.
Thank you for considering my cover letter.
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
-Online distance working
-Extreme programming, Agile methods.
-Personalized service.
-Full back-end and front-end programming.
-Software architecture and engineering.
-Expertise since 90s in business's systems
Ask Portfolio
Cloud services: GAE programming, Google API services
Office Excel Access programming
ERPs open source programming (PHP, Python)
DBA, SysAdmin: MySql, PostgreSQL
ASP.NET and classic programming with VS 2017
Websites Wordpress Joomla custom Access-like for buisnesses
Python for ETL crawling scraping
.NET VS 2017 VB.NET app SQLite DB
Extract, Convert, Transofrm any data any format any source any target.
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 excel forms to work with the Access database as requested.
I look forward to hearing from you. Thanks.
Kind Regards,
Martin C.
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 involve funding of over $ 3 million, including a centralized system for a US company on Fortune Global Top 50 list, a tracking system for a Boston city authority that’s used by its 60+ offices across the city.
I’m currently in charge of a centralized MS Access database that supports daily work of 400+ employees. I developed this database with VBA programming, designed UI, built in tracking functions and reporting features, and on a monthly basis add 3-4 new tracking forms for short-term pilot programs.
My experience and expertise would be a great asset to your project. Look forward to hearing from you.