You have chosen to sponsor your bid up to a maximum amount of .
I have created a Customer Service database using MS Access that will be used when customers call in to comment and/or report tech and non tech product issues. This db will be mainly used to track product issues that may or may not result in a CAPAs. We are required to monitor and log all such inquiries. Ideally it would be great to monitor all customer related issues here, including each call, but this is good start.
Basically when a new issue arises our Customer Relations rep will open this db and see the Main Menu. From there they should be able to:
Create new or edit and existing Customer Record
Create/edit a Post Sales Customer Feedback Report record
Generate a CAPA Report showing all open and closed CAPA issues
Generate a Customer Report showing all PSCF Reports/CAPAs for that customer.
It should also have the function of printing individual Post Sales Customer Feedback Report records/reports (duplex printing). The format of the PSCFR must be as is.
Functionality wise… on the Post Sales Customer Feedback Report… when any one of the fields labeled Customer ID, Customer Name, or Company are entered it should pull up the other general fields automatically… (i.e. if Customer Name is entered… data for Company, Customer ID, Telephone and Email should all pull up automatically from the Customers table).
Assistance is needed to finalize the db with the above functions/relationships.