Premiado

Access recipe costing and inventory database - repost

I need a database for calculating recipe costings.

TABLES

As I see it this would consist of;

Table 1: Suppliers - Name

Table 2: Ingredient category - category

Table 3: Units - Units

Table 4: menu sections - sections

Table 5: Ingredients: Ingredient name, supplier name (drop down from table 1) Ingredient category (drop down from table2), unit (drop down from table 3) cost per unit

Table 6: recipes -

For the recipe costings themselves I need to be able to add multiple ingredients, anything from 3 to 30 so it needs to be flexible. Also, I need to be able to add other recipes as ingredients. This could be a separate section but again I need a lot of flexibility in how many I can add. Ideally the form would start off with 1 drop down for ingredients and 1 for recipe ingredients with a button or something to add more as needed, I don't know if that's possible though.

The info I need on the recipe table is;

name

menu section(drop down table 4)

recipe yield

recipe yield unit (drop down from table 3)

ingredients (multiple drop downs table 5 bringing over unit and cost per unit) Plus field for inputting quantity

recipe ingredients (multiple drop downs of recipes ordered by section/alphabetic bringing over unit and cost per unit) Plus field for inputting quantity

Recipe cost: each ingredient and recipe ingredient quantity multiplied by the cost, all added together and divided by the yield amount.

Table 7: Dishes

Basically a copy of table 6, excluding the yield and yield unit and adding a selling price field.

REPORTS

1. I will need a printable report of all ingredients, ordered by supplier then alphabetical with current prices and an empty filed next to each for price checking.

2. A report listing all recipes from table 7 detailing name, recipe cost, selling price and a calculated field for each recipe showing '1-(recipeCost/sellingPrice) expressed as a percentage to 2 decimal points.

FORMS

I would want a auto start dashboard consisting of;

Dash 1 - report 1, report 2, add items subform, edit items subform, other subform

Add items subform: add ingredient (new record form for table 5), add recipe (new record form for table 6) add dish (new record form for table 7)

Edit items subform: edit ingredient (new record form for table 5), edit recipe (new record form for table 6) edit dish (new record form for table 7)

If it is possible some way of searching for a particular item in the edit forms would be very useful.

Other subform; links to edit form for the first 4 tables

Habilidades: Processamento de Dados, Excel, Microsoft Access, Microsoft Exchange

Ver mais: recipe inventory database, access recipe costing, searching supplier, all recipes, access subform data entry, access subform, Recipe, inventory database, costing, auto supplier, access points, access reports data entry, data entry inventory database, recipe table access, recipe costing form, costing report, excel access table, excel quantity multiplied, inventory dashboard, inventory reports access database report, want know cost data entry, excel inventory record, inventory forms access database, access recipe costing database, selling database

Acerca do Empregador:
( 0 comentários ) United Arab Emirates

ID do Projeto: #5132000

24 freelancers are bidding on average $515 for this job

Prashantskin

[url removed, login to view] I have gone through your project requirements. I will develop your application of recipes and ingredients in Microsoft Access. It will be flexible all the way that you want. Please send existing data/file Mais

$555 USD in 3 dias
(524 Comentários)
7.2
rhomeu

Hi, I am a MS Access expert and there's no doubt I can build the MS Access program that you wanted. I have done a lot MS Access projects as you can see it on my profile. I can definitely help you with your requ Mais

$500 USD in 5 dias
(66 Comentários)
7.0
torajiv

I remember bidding for this project earlier. Please let me create a sample db for your review - send me details of all the fields that you might be necessary for each table. regards Rajiv

$500 USD in 3 dias
(161 Comentários)
6.8
mail2vimalarora

Hi.. I have gone through your requirement of database application required for recipe costing and inventory maintenance. Feel fully comfortable in undertaking the project to its completion as I have done Access DB proj Mais

$500 USD in 7 dias
(93 Comentários)
5.9
jawadaman

Hi I am interested in this project. I am an experienced professional. If interested in hiring me then please let me know so that we finalize the requirements, timelines and price. Regards, Jawad

$500 USD in 3 dias
(71 Comentários)
5.6
farr4u

Hi, Access VBA expert here, you need a lot of flexibility on your user forms, (for a single recipe there will be multiple Ingredients) this can be easily achieved, also what I understood is that one recipe can be a co Mais

$500 USD in 3 dias
(45 Comentários)
5.5
nlukovic

Hi, I have read and understood your requirements. I have some ideas to improve database. You will need to have one table for the Recipe (it will have next fields: name, menu section(drop down table 4), recipe yield, Mais

$500 USD in 7 dias
(18 Comentários)
5.1
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if you want i will also send demo of my work or you can download from my profile also (V Mais

$555 USD in 3 dias
(15 Comentários)
4.9
NourElDeen

Dear Sir, I'm expert with access, i'd like to help with your task. Kind Regards, NourElDeen

$500 USD in 7 dias
(44 Comentários)
4.8
winnet21

Hi, I have experience with this project please refer programs that I done : [url removed, login to view] I happily if work with you in this project. Best Regards winnet21

$500 USD in 25 dias
(16 Comentários)
5.2
cyware

Dear sir, I have lots of experience in Access - more then 10 years. I'm fluent in English with no strange accent so we ca use skype or I can call you. I have made lots of projects with user/remote DB system and Mais

$500 USD in 7 dias
(16 Comentários)
4.9
dobreiiita

Happy to help you out.... Please contact for further communication. I have experience in database projects. Thanks Aniruddha dobre

$526 USD in 7 dias
(36 Comentários)
4.9
infoshree80

Hi, Having more than 12 years of experience in development.I have gone through your requirement.I have done so many inventory application before. I would like to do this job as it matches my skills and development Mais

$500 USD in 26 dias
(17 Comentários)
4.8
SajjadHussain14

Hi, I could share a working demo based on your specific needs. Once you get convinced with demo, we could move forward for payment. Let me know if you are interested. Regards,

$500 USD in 15 dias
(3 Comentários)
3.3
elboukharimu

Hi, I'm very interested helping you creating your Access database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some Mais

$500 USD in 10 dias
(9 Comentários)
4.5
Reza2012

Hi I have more than 10 years experience in database administration and software development using Oracle Database and Oracle Application. I have worked previously using recipe database. Thanks.

$500 USD in 15 dias
(2 Comentários)
2.7
ziafar

hello I've done this project for another employer. the proof is in the following link with feedbuck which shows the satisfaction of the employer. [url removed, login to view] Mais

$500 USD in 0 dias
(4 Comentários)
3.6
nawazwasif

Dear sir I have the ability to provide what you are required. For my previous experience please check my portfolio or ask for a sample work................ thanks

$555 USD in 20 dias
(4 Comentários)
2.0
robtech2013

Hello I am interested in your project, I am new to freelancer but i have had 7 years experience in the IT field.I always do my work on time as scheduled and I will be available at any time my help is needed .For now Mais

$555 USD in 3 dias
(0 Comentários)
0.0
AVKDevelopment

A proposal has not yet been provided

$500 USD em 1 dia
(0 Comentários)
0.4