MS Access Database modifications

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
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.

Skills required:
Data Processing, Microsoft Access, Technical Support
Qualifications required:
us_eng_1 US English - Level 1
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 250
in 3 days
Hire Premshanks
$ 155
in 10 days
Hire winghei
$ 222
in 3 days
$ 210
in 7 days
$ 194
in 7 days
$ 242
in 5 days
$ 122
in 6 days
$ 262
in 5 days
$ 242
in 7 days
$ 200
in 3 days