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:
Incident lodged by –
First Name/Last Name
First Name/Last Name
Date of incident
Year of incident/ quarter 1, 2, 3, 4 (count and trend yearly, quarterly
Time of Incident
Outlet (drop down box, 20 outlets listed, ability to easily add more for future)
What did customer eat (ability to add as required, automatically count to trend)
Type of incident – Possible Food Illness/Foreign Object/Food Allergen/Quality
What time did symptoms start
what where symptoms – Nausea, Vomiting, Diarrhea, Stomach Cramps, Fever/Sweating, headache, Dehydration, OTHER-input box (drop down box/check box, ability to add more multiple select
What did customer believe caused illness
What allergen was involved (drop down – crustacean, seafood, dairy, egg, soy, gluten, sesame, nuts, peanuts, OTHER- text field add for future use, trending count
What foreign object was involved (drop down box with several items, ability to easily add more and use, and trending count
was doctor visited Y/N
Was food poisoning confirmed Y/N
Was a sample sent for testing Y/N
Was a good will gesture gives Y/N
details if Yes
number of covers, items sold (optional0
Was Micro testing Completed Y/N
Media attachments, text, picture, email
Note area for details of incident/corrective action, other comments
Is incident closed Y/N
Date incident closed
• Want option to assign other people to action if required, reminders using email form perhaps
• Reminder if incident not closed within 3 weeks
• All fields should be able to be counted, sorted for trending
o Quarter particular year
o Type of incident
o Outlet implicated count totals, year, month quarter etc
Ability to pull details from incident such as customer name, address and deploy into a format letter (that can be edited) would be good
• Want as many reporting and trending options available as possible, also to compare data for reporting.
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 outlet, etc.
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.
37 freelancers are bidding on average $177 for this job
Hi i'm a a computer engineer from Greece with working experience in msaccces projects for more than 4 years. If you are interested dont hesitate to contact me. Have a nice day!