Access recipe costing and inventory database - repost

I need a database for calculating recipe costings.


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;


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.


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.


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

Skills: Data Entry, Excel, Microsoft Access, Microsoft Exchange

See more: 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

About the Employer:
( 0 reviews ) United Arab Emirates

Project ID: #5132000

23 freelancers are bidding on average $515 for this job


[login to view URL] 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 More

$555 USD in 3 days
(526 Reviews)

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 More

$500 USD in 5 days
(66 Reviews)

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 days
(167 Reviews)

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 More

$500 USD in 7 days
(115 Reviews)

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 days
(76 Reviews)

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 More

$500 USD in 3 days
(45 Reviews)

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, More

$500 USD in 7 days
(18 Reviews)

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

$500 USD in 7 days
(50 Reviews)

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

$526 USD in 7 days
(36 Reviews)

I have 8 yrs of Exp in VBA,VB6, 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 More

$555 USD in 3 days
(15 Reviews)

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

$500 USD in 25 days
(16 Reviews)

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 More

$500 USD in 26 days
(17 Reviews)

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 days
(3 Reviews)

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 More

$500 USD in 10 days
(9 Reviews)

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 days
(2 Reviews)

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. More

$500 USD in 0 days
(4 Reviews)

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 days
(5 Reviews)

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 More

$555 USD in 3 days
(0 Reviews)

A proposal has not yet been provided

$500 USD in 1 day
(0 Reviews)

I will bring over 19 years experience developing Ms Access Applications. I am available and ready to begin immediately should you elect to award the project to me.

$555 USD in 3 days
(0 Reviews)