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.
9 freelancers are bidding on average $77 for this job
Unfortunately I haven't got any previous feedback on Freelancer for you to judge my ability to do this job, please view my portfolio to see samples of MS Access projects that I have developed in the past. Thank you.