MS Access Database

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!

Compétences : Excel, Microsoft Access

en voir plus : vendor database ms access, quote lead, microsoft project import, microsoft access job, manufacturer search, job quote example, job ms access, i need an access database, import ms project, access vendor database, job access, database vendor, all po, ms access job, customer database in excel, pull-up, MS Access Database, import database, database in excel format, database build, database build - i need, c# with access database, c with access database, bill of materials, access microsoft

Concernant l'employeur :
( 5 commentaires ) Garden Grove, United States

Nº du projet : #1054474

Décerné à:


Ready to start now...

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(134 Commentaires)

3 freelance font une offre moyenne de $163 pour ce travail


I'd to help.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(1 Évaluation)

I can do this

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)