Evaluation report

[mikemwa]

I want to create a form so we can evaluate our services from a form we send out to our customers. There are 15 questions. The customer checks either Exceeds Expectations, Meets Expectations or Falls Below Expectations. Is there a way to evaluate that information in Access per customer and all customers together so we can see where we need to improve?

 

[lespaul]

a simple survey database should do what you want:
[tt]
Questions
QuestionID
QuestionText

Answers
AnswerID
AnswerText
AnswerScore

Customers
CustomerID
CustomerName

CustomerSurveys
SurveyID
CustomerID
SurveyDate

SurveyAnswers
SurveyID
QuestionID
AnswerID[/tt]

now this assumes that each customer can fill out the survey more than once so that you can evaluate outcomes over time to see if individual customers impressions have improved or declined over time.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[mikemwa]

Here is an example of a few questions on the form.
(Had to put periods in so things would somewhat line up)

.............................Meets.........Exceeds ........Falls Below
..........................Expectations....Expectat ions....Expectations

1. On Time delivery ________ ____X_____ __________
2. Quality of Service ____X___ ___________ __________
3. Prices of Services ____X___ ___________ __________

There are 12 more questions and a place after that for a comment
We mail these out and get them back. I want to put this information in Access and somehow analyze/evaluate it to see where we need to improve per customer and all customers as a whole. I’m fairly new to Access so I need a little more help than most of you people to put this together.
And yes there is no reason that it couldn't be filled out numerous times troughout the year.

Thanks

 

[lespaul]

It's usual with answers like these to assign a score to Meets Expectations (5), Exceeds Expectation (3), Falls Below Expectations (1) to allow comparisons and calculations.
[tt]Questions
QuestionID QuestionText
1 On Time Delivery
2 Quality of Service
3 Prices of Services

Answers
AnswerID AnswerText AnswerScore
1 Meets Expectations 5
2 Exceeds Expectations 3
3 Falls Below Expectations 1

Customers
CustomerID CustomerName
1 Joe Blow's Shop
2 Sally's Beauty Shop
3 Sam's Plumbing

CustomerSurveys (each customer has completed a survey twice - once in 2005 and once in 2006)
SurveyID CustomerID SurveyDate
1 1 1/15/2005
2 2 1/16/2005
3 3 1/18/2005
4 1 1/16/2006
5 2 2/1/2006
6 3 3/15/2006

SurveyAnswers
SurveyID QuestionID AnswerID
1 1 1
1 2 2
1 3 1
2 1 2
2 2 3
2 3 1
[/tt]



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dhookom]

You might want to try the "At Your Survey" demo at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

It uses a structure similar to Leslie's suggestion.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]