Job Record Database
- or -
Post a project like this$$
- Posted:
- Proposals: 11
- Remote
- #101632
- Expired
Access Database Developer, Microsoft Access Developer,MS Access VBA developer, Access Developer, SQL Server Developer
City of London
42487776179574510665611092311229122127923672323765676150193388
Description
Experience Level: Intermediate
Dear Sir/Madam
I am looking to get a price for putting together a database for keeping a better record of jobs. We are an Enabling and demolition company and do not have 100's of jobs on the go.
Ideally I want an Interface type database using Access or filemaker. It only needs to be shared across our PC network. Many years ago I was in the print industry and we had a database created from filemaker so I know it can be done.
It needs to contain, Customer Contact Record, Supplier Record, Quotation Record and Job Record.
I want to be able to export contact details to Outlook etc.
Customer Record to contain all usual info plus notes and have a short code, same with suppliers.
When we tender for a job we give it a quote number and at moment is entered into a book, there is usually a hold wad of paper that goes into a file. It would be good to be able to run say an A4 Sheet off from the record to stick on file with details. Because of nature of work we source outwork and would like to be able to enter supplier costs etc, add in our costs etc. This helps us when we look back after the event
If job become live I would want to be able to create a Job Record and bring in any details from the quote sheet.
An extra added to the Job Record would be to generate an Order based on an A4 template with the job number as order number.
Attached is rather rough idea of what I want.
I need costings to present to my boss
Regards Alan Knight
I am looking to get a price for putting together a database for keeping a better record of jobs. We are an Enabling and demolition company and do not have 100's of jobs on the go.
Ideally I want an Interface type database using Access or filemaker. It only needs to be shared across our PC network. Many years ago I was in the print industry and we had a database created from filemaker so I know it can be done.
It needs to contain, Customer Contact Record, Supplier Record, Quotation Record and Job Record.
I want to be able to export contact details to Outlook etc.
Customer Record to contain all usual info plus notes and have a short code, same with suppliers.
When we tender for a job we give it a quote number and at moment is entered into a book, there is usually a hold wad of paper that goes into a file. It would be good to be able to run say an A4 Sheet off from the record to stick on file with details. Because of nature of work we source outwork and would like to be able to enter supplier costs etc, add in our costs etc. This helps us when we look back after the event
If job become live I would want to be able to create a Job Record and bring in any details from the quote sheet.
An extra added to the Job Record would be to generate an Order based on an A4 template with the job number as order number.
Attached is rather rough idea of what I want.
I need costings to present to my boss
Regards Alan Knight
Alan K.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
10 May 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies