Need MS Access Database Designed with Look up Form for BOM

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: access bom, access bom database, bom access, access bill materials database, access bom sample, bom access form, access form bom, sample bom access database, bom database access, access bill materials sample database, sample access bom database, access database bill materials, access bom project, access bom spreadsheet, inventory bom database access, access database bom, access bom form sample, bom access database, access bom inventory, bom access sample, bom sample access database, access bom form, vendor database ms access, i need an access database, how to make an excel spreadsheet look like a form

About the Employer:
( 2 reviews ) Vista, United States

Project ID: #1130258

Awarded to:


Hi there, I'm a Professional Access Developer. I can create this database no problem, provided you choose me as your provider quickly. As I'm on GMT time, I can begin work at 9am UK time tomorrow. I'll need a li More

$100 USD in 3 days
(9 Reviews)