MS Access Database modifications

This project received 14 bids from talented freelancers with an average bid price of $182 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online