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

IN PROGRESS
Bids
23
Avg Bid (USD)
$174
Project Budget (USD)
$30 - $250

Project Description:
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 assembly...so 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, etc...so 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 PST...so 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 required:
Microsoft Access
Hire davidhancock74
Project posted by:
davidhancock74 United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 200
in 3 days
$ 300
in 4 days
Hire MattThrower
$ 222
in 7 days
Hire expertcoder1vw
$ 155
in 3 days
$ 189
in 5 days
$ 105
in 4 days
$ 90
in 4 days
$ 177
in 3 days
$ 201
in 1 days
$ 115
in 1 days