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 freelance font une offre moyenne de $177 pour ce travail
ID : 8545706 Greetings, We are interested to work on this project, please find my comments inline with yours, .I'm looking for someone that can build be an fairly simple solution for tracking customer complaints. Plus
Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by go Plus
Hello, this is just a quick note to help trim my bid. I'm hoping to hear back on the following items before placing my final bid. 1. I could not find the image mentioned in your project description, could you send Plus
HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data Plus
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Plus
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!
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases Plus
Hello, From your project declaration, its the kind of job I have been experienced very well. I had been working as a senior programmer responsible for financial system developed in MS Access for over 6 years. I had bee Plus
Hi, I am a computer professional with over 3 years of IT experience. I have a good typing speed of 55 WPM. I am proficient in computer skills and tools like Word, Powerpoint and Excel. I also have experience working Plus
I recently completed a project like this for another customer here on Freelancer. What you're describing is a fairly simple database that I should be able to provide to you within 24 hours, provided I get the informati Plus
Dear Sir, I have +5.5 year experiences in ms access programming To Provide Quality,modular and object oriented coding. Thanks & Regards
I'm a professional Customer Service Rep. in my previous job. With reference to my work experience. I satisfy all the requirements for this job. I'm sincere with my work and would never let you down in anyway. I promise Plus
Hi there - my name is Paul. I have more than 25 years of experience in designing and developing MS Access applications especially for small and medium sized enterprises. If you are looking for an experienced developer Plus
Hi, I have been into developing software for the past 7 years. I think it's better use .net with sql server a great combo just apt for the situations like you said. Please go through my portfolio for my past work Plus
Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus
I believe I possess the necessary skills and experience you are seeking and would make a valuable addition to your company. As my resume indicates, I possess more than seven years of progressive experience in the Ad Plus
Your project is relatively straight forward and simple. I'm bidding it 7 days is to allow any major modifications require. However, you still can contact me for modification if require after the project completion. Plus
I'm an Informatics Engineering student based in Indonesia. I have made an accounting application for management building company in South Jakarta. Its function is to analyze false detection in accountancy journaling an Plus