Đã hoàn thành

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!

Kĩ năng: Excel, Microsoft Access

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Garden Grove, United States

ID dự án: #1054474

Được trao cho:


Ready to start now...

$150 USD trong 3 ngày
(134 Đánh Giá)

3 freelancer đang chào giá trung bình $163 cho công việc này


I'd to help.

$190 USD trong 5 ngày
(1 Nhận xét)

I can do this

$150 USD trong 5 ngày
(0 Nhận xét)