Access Database for Purchase Orders/Tracking

In Progress

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: Microsoft Access, Visual Basic

See more: tracking company, sales rep job, parts database access, microsoft phone number, microsoft access parts database, microsoft access job, look for project managers, complete fabrication, company for microsoft installation, associated materials, access vendor database, access parts database, access job tracking database, microsoft project price, database vendor, sales rep company, job descriptions for project managers, purchase, purchase order, orders, multiple projects:need phone, FABRICATION, project tracking access database, project 2013 access, tracking database access

Project ID: #5030280

Awarded to:

torajiv

I am an exclusive MS Access developer and have completed over 150 such projects in the past three years - all with a 5 star feedback. I think you have explained your requirements very well and I would think that you k More

$225 USD in 3 days
(76 Reviews)
5.9

35 freelancers are bidding on average $422 for this job

rhomeu

Hi, I am a MS Access expert and there's no doubt I can build the MS Access program that you wanted. I have done a lot MS Access projects as you can see it on my profile. I can definitely help you with your requ More

$555 USD in 5 days
(56 Reviews)
6.8
customizedata

I have gone through the stuff. My suggestion is we should use .net (C#) for devlopment and SQl server as a backend database.As the number of users expand. MS Access is not as good as SQl server and c# based GUI is.

$666 USD in 25 days
(61 Reviews)
5.4
winnet21

Hi, I have experience with this project, I send you a small example that I had programmed for customer you please download example here : https://hotfile.com/dl/243889748/ba45780/POS_NEW1212.zip.html you ple More

$350 USD in 20 days
(20 Reviews)
5.4
MarlinSoftware

Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your detailed specific More

$500 USD in 15 days
(17 Reviews)
5.3
diegogarcia0531

Hi, I can do the job, very skilled MS Access developer, just award it to me, and consider it done Regards Diego

$420 USD in 10 days
(27 Reviews)
5.3
infoshree80

Hello, I have gone through your requirement . I have done so many inventory and Order management application. I have worked on so many modules Like Purchase,Sales,stock etc. I would like to do this job as it m More

$250 USD in 20 days
(20 Reviews)
5.2
piyushdpatel

I have 8 yrs of Exp in VBA,VB6,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start if you want i will also send demo of my work / you can download demo from my profile als More

$333 USD in 7 days
(14 Reviews)
4.9
expertcoder1vw

Hi, I'm an expert Access and database developer and have experience with creating similar databases. I can develop this database for you according to your requirements, and can deliver in 1 week, with updates on a dai More

$526 USD in 5 days
(19 Reviews)
4.9
cheapexcell

Hello, I am an expert in Access with over 10 years of experience. Ready to start..... Thanks, Alex

$412 USD in 10 days
(33 Reviews)
4.8
ielkfarna

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$684 USD in 30 days
(9 Reviews)
4.4
expertatwork

Hey Jay,Experts team here. We have went through your description and we are feeling comfortable and are ready to discuss further. Are you using WINDOWS or MAC ? All the managers have to update the tables simultaneously More

$250 USD in 8 days
(22 Reviews)
4.1
mail2vimalarora

Hi.. I have gone through project details and can handle your task to achieve its completion effectively and in timely basis. Waiting for your response to discuss further. Thanks.

$277 USD in 10 days
(13 Reviews)
4.1
sinfulm3

Hello Sir, I'm a freelance MS Access developer and have developed several databases for small firms. I have done a database almost similar to what you need. It was a PC repair database where in repair job orders are More

$450 USD in 12 days
(14 Reviews)
4.1
matthewsandrews1

Hello My name is Matthew Andrews have a look at my resume, please consider my bid. http://www.linkedin.com/pub/matthew-andrews/2a/2a9/679

$315 USD in 10 days
(3 Reviews)
3.9
davidt999

Hello! I have over 20 years of programming experience with eight years of MS Access. See my portfolio for samples of my work. I can supply others and references if you like. I have created numerous Access applica More

$283 USD in 10 days
(6 Reviews)
3.9
farr4u

Hi, Access VBA expert here, my approach will be to make the user form dynamic as the no. of materials for individual purchase orders will vary, also these purchase orders will be generated on dynamic access reports by More

$250 USD in 7 days
(13 Reviews)
3.8
esadeghi59

I have over 10 years experience in VB, .NET & MS-Access & ready to start working. My services are fast & reliable and you can trust me to do your project.

$350 USD in 7 days
(6 Reviews)
3.5
SajjadHussain14

Hi, I have developed similar system for a Duabi Based company. I could share a working demo based on your specific needs. Once you get convinced with demo, we could move forward for payment process. Let me know if y More

$333 USD in 5 days
(3 Reviews)
3.3
pankajgarg10

More then 7 years of working experience in Telerik Open Access ORM, Entity FrameWork using Code First, Database First Approaches, ASP.NET, Window Service, Web Service, MVC 3.0, MVC 4.0, C#, VB.NET, SQL Server, Access, More

$250 USD in 7 days
(2 Reviews)
2.8
web2printexpert

1. We have big experience in MS Access, Visual Basic, VBA, Excel, Word, Visual Basic.NET, C# , Crystal Reports and MS SQL, MySQL 2. We have developed lots of applications on MS Access - pure MS Access applications, More

$555 USD in 5 days
(1 Review)
2.8