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
Hello
I am an expert on access, I can meet your need.
we can exchange more information on the project?
I already want to get an idea on your version of Access and the volume of the database (how online almost)
regards
$300 USD en 5 días
5,0 (2 comentarios)
3,2
3,2
26 freelancers están ofertando un promedio de $308 USD por este trabajo
Hi,
I am giving you bid above your maximum amount as I think there is more work on this db than estimated 20 hours. If you need qualified person that can actually do it, here is my bid.
Thanks!
Hi
That's an interesting project - will be good break from the routine invoicing and billing apps that I have been building!
From what I have understood what you need is a basic master table where all the ingredients, theri supplier and price are recorded.
Once this is done you can create a recipe and add as many of these ingredients as you want (there is no limit to the number). Adding a predefined recipe is also possible as you will just need a code that will look up that recipe and add all the ingredients of that recipe to the current one.
In addition to this I can give you an option where - once you select an ingredient you can see all the suppliers with different prices so that you can select the one with lowest price or the one with best quality.
Reports module will also be unlimited - where I can give you a form with a list of existing reports - you can open any report by selecting any one and clicking the "preview" button. I can also give an option to export this report data to an excel file if required.
I can work with either 2007 or 2010 version of MS Access.
If can send me some ingredient data I will be happy to provide you with a sample database for evaluation.
Do let me know if you have any questions.
regards
Rajiv
VB, VBA and Databases expert for over a decade. Master in Information Systems.
I have delivered similar projects in the past.I have the knowledge and the skill.
Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification. Please view my portfolio for some examples of my work.
HI, access VBA expert here, ready to start, I want to send you a DEMO application that will give you an idea how I will meet your requirements. for e.g. you mentioned "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." This is possible using dropdown combo boxes, list box and 3 buttons, i.e select value from dropdown click add and value will be added to list box and so on. If you send me a reply message, I will be able to send you a demo application. Regards.
I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess.
I have developed many applications in VB6,VBA,VB.NET.
I have already developed this type of project if you want i will also send demo for same....
Please Check My PM
Hello Sir,
I'm a freelance MS Access Developer. I have developed several databases for small forms.
I could fully developed the Recipe database of yours. You can add unlimited ingredients on the recipes via subform. Table 7 can be neglected and can be a form instead.
Looking forward to discuss with you this matter.
Regards,
Aye
Hello!
I have over 20 years of programming experience with eight years of MS Access. See my portfolio for samples of my work. I can supply others and references if you like.
I can definitely build your recipe costing project.
I am a professional. I know your project is important to you. I will deliver *all* of the Access files to you and will not play games with you or your project. I have great attention to detail and I will stick with the project until it works to your satisfaction. I also know you have a budget, so my fee is negotiable.
I can start on your project immediately.
Thank you for considering my bid.
David
Over 20 years of experience in organization environments with much pressure and critical situations. VB.NET, VB6, VBA, SQL Server, MSAccess, ASP.NET, HTML5, Javascript, jQuery, CSS3 at your disposal.
I can do this project either in a MSAccess db or with MSAccess as the main storage and a windows desktop application as a front end
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 samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. We can also talk about it in Skype, this is my ID : ELBOUKHARIMU. Please send me all other details about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
Hello
I am a professional software developer (specialized in Microsoft technologies) with twelve years of experience in developing and maintaining.
Can you trust me this job ?
I reviewed you Recipe cost database, I can build the database as requested by you.
There will be slight change in the way of build, table 6 is stored into two table.
The complete build will bring the all the functionality requested below, review my portfolio for my skills in access.
hi. I have more than 10 years develloping and populating MSaccess program and database. I'm ready to provide you my xp on this project. please hire me. regards.
waza
Could you provide me the current access database file, Sir? Or you need me to create from beginning based on your description? I estimate this wont take more than 5 work days, in case I should create the database from beginning. But, if you already have it, this would be 3 work days.
Dear Employer,
I hereby express my interest in working on this project. I have a Diploma in Computing, with skills and experience in developing relational databases using SQL, MySQL and MS Access. Therefore, if awarded this project, I will create a Microsoft Access database with forms, tables and the necessary queries.
Kindly consider my bid and let's get this project done right away.
I am waiting to here from you.
Thank you.
Best Regards,
Joe.
Yes, understood this project
20 years experience ...
Just call me,
nista posebno , ali da Vam ne objasnjavam u detalje ni ko sam ni sta znam, ako zelite da saradjujemo samo me pozovite
Hi, i have experience in this kind of projects. I could complete it withou any doubt as soon as possible, accept my offer and i will start right now. Thanks and regards.