Customer / Job Booking Databse (Access)

I am in need of a database which will be used to log jobs into for repair. It will require fields such as name, address, postcode, telephone number, mobile number & email address, date, service type (fast, regular), and a field for a unique barcode/job number.

Second to this, it will need two text fields of say 500 characters each. The first field will be the fault reported by the customer, the second field will contain text input by the engineer detailing the work which has been done.

Thirdly, it will need fields for the job such as cost, time taken and status (to be done, in progress, completed, waiting for parts, waiting for customer response etc).

I'm sure there will be some small other bits to do as the database is refined and customised to our needs.

There will also need to be a simple front end so the database can be searched by customer name for example, to quickly locate their job, and of course a front end 'form' to enter all this information.

There maybe a requirement to share the database so that jobs can be booked onto it from two different computers. Please consider this when bidding, though this will be a separate project in the future.

Taidot: tietojenkäsittely

Näytä lisää: waiting jobs, unique jobs, telephone customer service jobs, small it job, service database access, second job, project engineer jobs, parts database example, parts database access, need second engineer, jobs the engineer, jobs engineer, input jobs, i need engineer to do, field service jobs, field service engineer jobs, field service engineer, field engineer jobs, engineer jobs, engineer job, engineer engineer jobs, email response jobs, email customer service jobs, email customer service job, database input jobs

Tietoa työnantajasta:
( 6 arvostelua ) New Milton, United Kingdom

Projektin tunnus: #391024