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.

Skills: Data Entry, Inventory Management, Microsoft Access

See more: 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

About the Employer:
( 0 reviews ) Australia

Project ID: #8545706

37 freelancers are bidding on average $177 for this job


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. More

$953 USD in 12 days
(214 Reviews)

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 More

$222 USD in 3 days
(122 Reviews)

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 More

$250 USD in 10 days
(2 Reviews)

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 More

$144 USD in 7 days
(25 Reviews)

pleas inform about next steps .

$250 USD in 5 days
(7 Reviews)

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 More

$155 USD in 3 days
(2 Reviews)

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 in 3 days
(2 Reviews)

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 More

$83 USD in 3 days
(4 Reviews)

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 More

$133 USD in 5 days
(4 Reviews)

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 More

$100 USD in 3 days
(2 Reviews)

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 More

$100 USD in 3 days
(1 Review)

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

$200 USD in 2 days
(2 Reviews)

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 More

$155 USD in 3 days
(3 Reviews)

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 More

$222 USD in 15 days
(2 Reviews)

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 More

$88 USD in 10 days
(1 Review)

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 More

$155 USD in 7 days
(2 Reviews)

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 More

$133 USD in 3 days
(1 Review)

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. More

$200 USD in 7 days
(0 Reviews)

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 More

$166 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$111 USD in 7 days
(0 Reviews)