Fermé

Access Database to keep track of customer complaints

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

Employee Number

Date

Guest Details-

First Name/Last Name

Mobile Number

Home Number

Address

Suburb

State

Postcode

Country

Membership Number

Incident Details

Date of incident

Year of incident/ quarter 1, 2, 3, 4 (count and trend yearly, quarterly

Quarter

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

Notes

Was a good will gesture gives Y/N

details if Yes

Investigation

Notes section

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 Item

o Year

o Quarter

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.

Compétences : Saisie de Données, Gestion des Stocks, Microsoft Access

Voir plus : trend micro, soy data entry, media covers, keep track customers, employee month picture, date entry home, data entry experience letter, data access interface, customer email template, customer data entry form, a soultion, access media, customer sales database access, customer complaint database access, customer contact database access, customer master database access, customer management database access, customer tracking database access, customer orders database access, aspnet access image database

Concernant l'employeur :
( 0 commentaires ) Australia

N° du projet : #8545706

37 freelance ont fait une offre moyenne de 177 $ pour ce travail

illuminesoft

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

953 $ USD en 12 jours
(214 Commentaires)
7.3
torajiv

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

222 $ USD en 3 jours
(122 Commentaires)
6.6
jcsconsulting

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

250 $ USD en 10 jours
(2 Commentaires)
4.2
farr4u

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

144 $ USD en 7 jours
(25 Commentaires)
4.5
AlexandrK1

pleas inform about next steps .

250 $ USD en 5 jours
(7 Commentaires)
4.1
zu02

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

155 $ USD en 3 jours
(2 Commentaires)
3.5
vapashos

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!

277 $ USD en 3 jours
(2 Commentaires)
2.8
workerbee1974

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

83 $ USD en 3 jours
(4 Commentaires)
3.0
Altantsetseg

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

133 $ USD en 5 jours
(4 Commentaires)
2.5
smiledheeraj

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

100 $ USD en 3 jours
(2 Commentaires)
2.1
carltmarshall

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

100 $ USD en 3 jours
(1 Commentaire)
2.1
swarm22

Dear Sir, I have +5.5 year experiences in ms access programming To Provide Quality,modular and object oriented coding. Thanks & Regards

200 $ USD en 2 jours
(2 Commentaires)
1.9
jrcarlos17

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

155 $ USD en 3 jours
(3 Commentaires)
1.4
paricoto

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

222 $ USD en 15 jours
(2 Commentaires)
1.3
gjampani

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

88 $ USD en 10 jours
(1 Commentaire)
1.1
ufasoft

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

155 $ USD en 7 jours
(2 Commentaires)
1.2
KelliRyan

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

133 $ USD en 3 jours
(1 Commentaire)
0.6
kemyee

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

200 $ USD en 7 jours
(0 Commentaires)
0.0
carlarizki

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

166 $ USD en 10 jours
(0 Commentaires)
0.0
sudiptachoudhury

A proposal has not yet been provided

111 $ USD en 7 jours
(0 Commentaires)
0.0