Access Database for Purchase Orders/Tracking

Avg Bid (USD)
Project Budget (USD)
$250 - $750

Project Description:
We are a cabinet fabrication and installation company. When we sell a job, it is necessary to order hardware and materials to complete it. As we normally have 8 or more projects going on each day, different project managers will enter the materials into the database on a per job basis. We would then generate purchase orders containing the accumulated materials of 2 or 3 days into vendor specific purchase orders and email/fax these to the vendors for fulfillment. Our company uses Access 2007 and newer.

The database would look like this…

Open database, start new “Job Materials Order”. Enter job name, job description, requisitioner’s name, Job installation date. Date would auto fill with current date and be editable. Project number would auto fill.

Item descriptions and quantities would then be entered into the order.
These items would come from a “Materials” table and the following information would be associated with each item. Item description, item purchase price, item sale price, item vendor, and item notes.

There would also be a vendor table that keeps the following information. Vendor name, vendor address, vendor city, vendor state, vendor zip, vendor phone number, vendor email, vendor rep, vendor email, vendor notes.

Purchase price of parts need to total, as do the sales prices.

Every 1 or 2 or 3 days, our purchasing department will generate purchase orders for our vendors. These purchase orders will be populated by the multiple “Job Materials Orders” described above. The different Job Materials orders must be select-able to include or exclude from purchase orders.

As materials arrive, they must be able to be marked off as received on the purchase orders and a date received field populated on the individual job orders.

Attached are some rough outlines of a job order, a purchase order, a vendor table and an items table.

Skills required:
Microsoft Access, Visual Basic
Additional Files: Purchasing database outline.pdf
About the employer:
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.

$ 555
in 5 days
$ 225
in 3 days
$ 666
in 25 days
$ 350
in 20 days
$ 500
in 15 days
$ 420
in 10 days
$ 250
in 20 days
$ 333
in 7 days
$ 526
in 5 days
$ 412
in 10 days