Closed

Access Database to keep track of customer complaints

This project was awarded to www1980 for $60 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

I'm looking for someone that can build be an fairly simple soultion for tracking customer complaints.


I would like an easy to use interface for adding in a new customer complaint. It would contain the following fields:

"NEW CUSTOMER ENTER"

Cust First Name TEXT FIELD
Cust Last Name TEXT FIELD
Customer Cell Phone Number
Customer Home Phone Number
Customer Address
Customer City
Customer State
CUstomer ZIP
Resturaunt involved in complaint (drop down field with 6 stores to choose from)
Notes Field: For additional notes on issue.


Fillng this out will add a new customer with the above information to the database.

From Here I would like the ability to search for customers by name and phone number duplicate names , complainers by store, etc.


The graphics on the submit and search forms don't need to be too special. I can fix that up later,


I'm not sure on this wanted addition but if possible, I wold like the ablity to select one of the customers from the database and use their information to fill out the valid blanks in a response letter that can be mailed to the customer. Like it pulls certain details, (FIRST NAME) and adds it to a template, (Address), etc.

I'm open to better suggestions. I have little experience with Access.

The example image shows how simple it has to be. Half of the fields listed wouldn't be required. It would be fairly simple on data.

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