Microsoft Access VBA/Database expert needed to design a CRM compatible database App for a small food delivery company.

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

We are a customizable, healthy meal delivery company and I need a Microsoft Access expert that can design database specific to my needs that will integrate fully with the online CRM that my company currently uses.

The CRM provides new orders as both emails and Excel reports thus This Access App needs to have the following major capabilities.

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 (select 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 3 part combinations of menu selected by each item

-to filter through all combinations based on customer preferences, nutritional information and food cost

Total Order generation

-To generate weekly totals for orders

-to generate shopping and prep list based on the orders


The program allows for filtering of combination result 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 based on their preferred selection of ingredients and their preferred range of nutritional values.

This program also takes a total of all orders for all clients for each week and generates a weekly prep and shopping list that will be scalable.

-Each meal is put together by combining 2-6 categories. The categories are as follows Meat, Vegetables, Carbohydrates, Sauces, Spices, and Garnishes

-Each category will have its own unique recipes/items.

The user will check off all their preferred recipes/items from each category.

-Each recipes/items will have the following values assigned to it Total Cost, Calories, Protein, Fat, Carbohydrates, Cholesterol, Fiber, Sodium There also needs to be multiplier 1/3, ½ , 1, 2, 3 for each category.

This multiplier option effectively multiplies the assigned values of each recipes selected from each category. This is for example if somebody wants to double the meat but half the vegetables.

-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

Квалификация: Обработка данных, Разработка баз данных, Программирование баз данных, Excel VBA, Microsoft Access

Показать больше microsoft access vba reverse, microsoft access vba iptc metadata, microsoft access vba serial comm port, crm software free, crm software for small business, crm software free download, google crm free, crm tools list, agile crm, free open source crm, free customer database software for small business, create user name password microsoft access vba script, open webpage microsoft access vba, microsoft access vba create timeline, microsoft access inventory form shareware edu design report, microsoft access vba screen scraping, database expert needed, print report pdf microsoft access vba 2007, microsoft access vba google maps, microsoft access vba php translation

О работодателе:
( 3 отзыв(-а, -ов) ) Port Coquitlam, Canada

ID проекта: #18546567

20 фрилансеров(-а) в среднем готовы выполнить эту работу за $341


Dear project manager, Hope you are doing well. I am working here from last 4 years full time and deliver almost 425 jobs with 100% client satisfaction. Please see my profile reviews . I have more than 6 years of Больше

$750 CAD за 14 дней(-я)
(187 отзывов(-а))

ID : 18546567 Greetings, We are interested to work on this project, please find my comments inline with yours in attached link. Also attached tasklist please go through the same. [login to view URL] Больше

$555 CAD за 15 дней(-я)
(225 отзывов(-а))

Hello , I have 5 years experience in MSAccess database, Sql, VBA programming. I am expert in design Reports, Userforms in MSAccess. II never ask for payments in front. You can release the agreed mileston Больше

$60 CAD за 3 дней(-я)
(214 отзывов(-а))

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Больше

$30 CAD за 1 день
(86 отзывов(-а))

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 Больше

$833 CAD за 15 дней(-я)
(71 отзывов(-а))

Hi, I am a professional MS Access and SQL database developer. I have gone through with your complete details and I can assure you that I will be able to provide you best support on this project. The scope of work is Больше

$750 CAD за 7 дней(-я)
(27 отзывов(-а))

I have 22 years MS Access programming in the public and private sector as well as writing VBA code against Outlook and Excel so your automation request is a piece or cake to me. I design multiuser Access DBs that also Больше

$444 CAD за 15 дней(-я)
(4 отзывов(-а))

Hello I would like to offer you a web based solution If you are interested let me know I have one customer from your country Thanks Valery

$555 CAD за 20 дней(-я)
(22 отзывов(-а))

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 Больше

$250 CAD за 3 дней(-я)
(16 отзывов(-а))

Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Больше

$155 CAD за 10 дней(-я)
(32 отзывов(-а))

Hello? How are you? I have good experiences in "Microsoft Access VBA/Database expert needed to design a CRM compatible database App for a small food delivery company." as you can see my profile for these (Data Proces Больше

$155 CAD за 3 дней(-я)
(9 отзывов(-а))

I have much ms access experience and would love to assist Relevant Skills and Experience Ms access vba database programming

$50 CAD за 8 дней(-я)
(11 отзывов(-а))

Dear Sir/Madam: I am interested in doing it, INPUTS and OUTPUTS well described will be enough to start ASAP. Kind regards. Remote Work Guidelines of my Software factory -Online distance working -Online Больше

$250 CAD за 20 дней(-я)
(4 отзывов(-а))

Please review my profile I am working with skills that you required for this job from 16 years. I am working with MS Access,Excel,MS SQL and VBA from long time. I can definitely help you in this job, to make your d Больше

$250 CAD за 5 дней(-я)
(1 отзыв)

I have developed, and updated dozens of Microsoft Access/Excel applications over the last 25 years. We will need to talk about a few minor issues. I hope we can work on this project together. Thanks for your time and c Больше

$1055 CAD за 14 дней(-я)
(0 отзывов(-а))

Greetings, I am an experienced database developer interested in your project. I have over 5 years of experience working with Ms Access databases. I have read your requirements and could implement your ordering system Больше

$100 CAD за 4 дней(-я)
(0 отзывов(-а))

If you need help in your thesis or any assignment [login to view URL] contact with [login to view URL] have a best team of researchers and writers. Guaranteed Plagiarism free work. Assignments Thesis Proof read Articles Больше

$222 CAD за 3 дней(-я)
(0 отзывов(-а))

Hi I developed Access database since office 97. so, I have plenty of experiences about Acess 97, 2013, 2017, ... I will do my best if you choose me. Thank you.

$55 CAD за 3 дней(-я)
(0 отзывов(-а))

Hi Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. W Больше

$155 CAD за 3 дней(-я)
(0 отзывов(-а))

I CAN DO IT;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;GIVE ME A CHANCE;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

$155 CAD за 10 дней(-я)
(0 отзывов(-а))