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


Guest Details-

First Name/Last Name

Mobile Number

Home Number






Membership Number

Incident Details

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


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

en voir plus : what is a data entry form in a database, trend micro, soy data entry, media covers, keep track of customers, how to keep track of customers, example of letter, employee of the month picture, date entry from home, data entry experience letter, data access interface, customer email template, customer data entry form, a soultion, access media 3, access data entry form template, access database data entry form, customer sales database access, customer complaint database access, customer contact database access, customer master database access, client track database access 2007, customer management database access, customer tracking database access, customer orders database access

Concernant l'employeur :
( 0 commentaires ) Australia

Nº du projet : #8545706

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(214 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(122 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)

pleas inform about next steps .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(7 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(4 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)