We require a system to be developed to be used by our operators in a specialized product support centre. Clients register their product datasheets with us and provide their customers with our number. Should their be an issue with a product, we would receive the call, have to locate the correct datasheet and provide an appropriate response. Once the call is complete, we need to capture the details of the call and generate a report that will be sent to the client.
We require the development of a system that can operate both over the web and also locally (with syncronization) to:
Be used to capture the client information and the datasheets.
Search the database in order to locate a datasheet
Open an incident record linked to the product
Generate a report and email it to the client.
Facilitate the addition and deletion of product datasheets to the database
Generate reports (incident by client, incident by type, produc list by client, etc)
It is expected that the project will deliver the ability to:
Add new clients, their details and their product datasheets to the database
Search the database to find the appropriate datasheet
Open up an incident report related to the product and capture the details of the incident
Generate a report and email to the client
Maintain the database record (add and delete datasheet records, update client details, etc)
This should all be delivered on a platform that can be deployed in such a way that operators can securely access the database from different locations, typically over the Internet, but also be syncronized locally to ensure availablity in the office should the connection to the Internet be lost.
An example of the MS Access program that we are currently using can be made available to potential coders.