You have chosen to sponsor your bid up to a maximum amount of .
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
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.