Find Jobs
Hire Freelancers

Local Microsoft Access Database and APP design a small food delivery company.

$30-250 CAD

Dibatalkan
Dibuat sekitar 5 tahun yang lalu

$30-250 CAD

Dibayar ketika dikirim
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
ID Proyek: 18613508

Tentang proyek

1 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
1 freelancer menawar dengan rata-rata $54 CAD untuk pekerjaan ini
Avatar Pengguna
local miscrofsof access databse app desing a dn developed 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.
$54 CAD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Port Coquitlam, Canada
5,0
3
Memverifikasi Metode pembayaran
Anggota sejak Feb 5, 2013

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.