Need MS Access Database Designed with Look up Form for BOM - repost


I have a spreadsheet that contains tons of data related to our shop's inventory: part numbers, vendor info, pricing, etc... I need that spreadsheet to be turned into Access Tables as needed and then a form created that allows me to look up inventory items via any of several fields and edit information for that line item and save. I also need a form that allows me to look up line items by any of various fields and then enter a quantity and have that quantity of that particular line item added to a BOM (bill of materials). Basically we build assemblies and know that it takes 7 of line item X and 9 of line item Y and 12 of line item Z to make one we need to be able to select those and have the ability to either print that BOM or export it to an Excel spreadsheet at the end...preferably both. This should be very similar to an Order / Order Details form / subform setup...I just haven't played with Access enough in recent years to remember how to do the look up queries, I prefer to sub it out. I have attached a sample Excel spreadsheet that has the fields for the inventory. When looking up inventory line items, I would like to sort by category then sub-category to get me closer to the item that I am looking for. The final BOM report should have room for a Project Name, customer contact information, then a list of all the line items included in the BOM with extensions of the price and cost per line item as well as a total price and cost for the whole BOM at the bottom. I need this done by Sunday 4pm if you can't do it by then please don't bother bidding. It should be really quick and pretty simple. Nothing fancy in appearance...just need the functionality.

Skills: Microsoft Access

See more: inventory database bom excel access, vendor database ms access, i need an access database, how to make an excel spreadsheet look like a form, database assembly, assembly database, a closer look, access vendor database, ms project price, microsoft project price, microsoft excel price, how to microsoft excel, database vendor, access subform, customer database in excel, MS Access Database , ms access 2013, c# with access database, c with access database, bill of quantity, bill of materials, bom sample access database, customer details database, pricing tables excel, customer order spreadsheet sample

Project ID: #4677678

Awarded to:


Hi David, I've just finished a similar inventory application with import and export facilities for another client. Please read my private message for the details of the bid. Regards, Steve.

$150 USD in 3 days
(0 Reviews)

21 freelancers are bidding on average $178 for this job


Res.Buyer I have gone through your project requirements regarding BOM.. I have already added this utility to already available access template of inventory. Please see PMB for further details I will complete the More

$200 USD in 3 days
(460 Reviews)

Hi, I have made many similar programs in Access. I ll send y a demo where y can find the functionality of BOM already working. It might need little tweaking to match yr needs.

$300 USD in 4 days
(21 Reviews)

I have over 9 years of MS Access development experience.

$222 USD in 7 days
(9 Reviews)

Access expert here. Can start now.

$155 USD in 3 days
(11 Reviews)

Please check your inbox. Thanks

$189 USD in 5 days
(2 Reviews)

Database Professional Freelancer.

$105 USD in 4 days
(3 Reviews)

Hi, Access VBA expert here, ready to start, plz chk pm for DEMO. Regards.

$90 USD in 4 days
(6 Reviews)

I am interested to do this.Lets begin

$177 USD in 3 days
(3 Reviews)

I am ready to start this project....

$201 USD in 1 day
(1 Review)

hello, Access wise is here. Let's begin

$115 USD in 1 day
(1 Review)

Good morning. I have over 15 years of experience building Access databases. I am available to start immediately. Please check your PMB. Thanks for the consideration. Best regards.

$150 USD in 5 days
(2 Reviews)

Done a BoM database before please email me if you want to see a copy. The way it works is similar to your requirements, so would act as guide for me to create yours. I would aim to have this ready for you on Friday so More

$250 USD in 2 days
(0 Reviews)

Good day, you may review my profile regarding this project. I'm an MS Access expert with more than 15 years of experience. I am originally from the USA and Europe, but currently reside in the Philippines and am the More

$277 USD in 4 days
(0 Reviews)

Hello, I can develop your application on your requirements, Freelance With 10 Years Of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public Or Private Sector.

$222 USD in 5 days
(0 Reviews)

Hi this is my work - building access databases for managing all sorts of businesses. Can do this for you and much more. Try me out

$111 USD in 2 days
(0 Reviews)

Yes i can do it in 3 days.

$100 USD in 3 days
(0 Reviews)

Very strong Ms Access Skills. Available and ready to begin.

$155 USD in 3 days
(0 Reviews)

I have more than 15 years of MS Access/Excel development experience. In past I have worked on Job estimating , Sales and Quotation applications. I have been working with a company which builds tailor fit solutions for More

$155 USD in 3 days
(0 Reviews)

I am experienced software developer.I can give you best quality application as per your requirements.I have gone through your requirements ,I assure the project to be completed on time with good Quality. looking forwa More

$155 USD in 5 days
(0 Reviews)

Dear Hiring Manager, I am working in IT sector for last 12 years starting from Junior Programmer-Senior Programmer-Tech Lead-System Analyst and Manager.Regarding my technical skills and deliverable or technical sup More

$250 USD in 2 days
(0 Reviews)