I need someone to build an Access database. It will need to import a bill of materials in excel format and compile a database based on the information in the excel bill of materials. Please see the attached example Bill of Materials.
I need the database to import: Part #, Item Description, Manufacturer, Vendor, Vendor Quote, Xenon PO, Date Ordered, Lead Time, Date Received.
I want to be able to open a database and search by either a keyword, part number, manufacturer or vendor, or Xenon PO number. The Xenon PO number will be a 9 digit number. The first three digits correspond to a customer, the next three digits correspond to a job number and the last three digits correspond to the actual PO number. I would also like to be able to search the database by customer and/or project number. For example, if I wanted to look at all the items ordered from a customer in a certain date range I could. Or if I wanted to look at all the items ordered on a specific project I could do that. I also need to be able to pull up all the items by a certain manufacturer or vendor.
Please contact me with any questions. Thanks!