design question

[Danny]

What would be the best way to capture the attached "Customer Satisfaction Survey" Access, Excel etc.

The plan is to take this survey once a month over the phone and provide a report about the outcome to the president.


Thank you in advance.

Danny

 

[KenHigg]

How many customers will you contact each month?

 

[Danny]

About 55.

Thanks,
Danny

 

[KenHigg]

If that's all you need, then I would say in Access, a simple table with one input form and a couple reports reports would do nicely! The upside to Access would be the input form and the custom push button reports you could do rather quickly...

 

[KenHigg]

The plan is to take this survey once a month over the phone...

The question isn't how many? It is by what method?

Did I miss something

 

[KenHigg]

If this is their first db, would you really subject them to all that normalization stuff? Looked to me like a single table would work fine...

And if they were only doing several surveys a week or month, seems Excel would work fine...

 

[KenHigg]

Danny, Do you just need a simple means to manage the results of this one survey or do you want to put the time and effort into doing a system that will allow you to do other surveys?

 

[Danny]

Ken,
I'm glad you ask. Actually, I should put some time and effort into designing a system that can be used to capture other surveys. The reason is that we have 4 departments (each with diffrent survey questions) and I was asked to design for now just for one department (as a pilot) to see the result. I'm sure that I'll be asked to do the same for other departments in the future. And, my goal is to get as much information as I could from the forum (how many tables, relationships, queries etc.) I need to create this survey database so I can use the same method for the other 3.

Thanks,
Danny

 

[ScottGem]

If this is their first db, would you really subject them to all that normalization stuff? Looked to me like a single table would work fine...

And if they were only doing several surveys a week or month, seems Excel would work fine...

In my opinion the answer is a resounding YES!!! A normalized database will pay dividends down the road. A survey database has a particular type of structure that will aid in entering and analyzing answers.

 

[KenHigg]

Danny,

In that case, I recomend you search the form on 'Survey' and see how the really good ones are done, making sure you get the hang of normalization...

If you get hung up on a concept, post back, there are some really good db'rs here!

 

[Danny]

survey db

Thanks,
I'll try to look at examples on the forum and put something together. If I have any problem or not sure about something, I'll post back.

Thanks,
Dan

 

[RuralGuy]

You might want to take a gander here:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%202000'
At Your Survey 2000 (354 KB) - By Duane Hookom

 

[Smart]

The attached db is a simple survey dbase I just knocked up.

You will have to add validation to the fields and Buttons.

Open the Form and fill in the fields click save record record and your selections will appear in the table Tab_Survey

 

[ScottGem]

A survey app should have a structure like this:

tblQuestions
QuestionID (PK Autonumber)
Questiontext

tblRespondent
RespondentID (PK Autonumber)
Firstname
Lastname
other info about respondent

tblResponses
ResponseID (PK Autonumber)
RespondentID (FK)
QuestionID (FK)
Response

That's a bare minimum. Depending on the strucutre of the surveys you might add

tblAnswers
AnswerID (PK Autonumber)
QuestionID
Answer

This will predefine answers to the questions. Answers are then displayed usinng combos that query tblAnswers.

If respondents will take the same survey multiple times, then you might have add a datestamp to tblResponses or a parent table that deals with that survey.

The main point here is that each question is a record in a table and each response to a question is a record in another table that identifies the respondent, the question and the response.

 

[KenHigg]

That's a good start, but there's still a lot missing

 

[ScottGem]

Like I said that's bare minumum. but at least it shows the correct direction.

 

[Danny]

Thanks everybody for your inputs. I will start putting something together and post back for your reviews.

Thank you,
Danny

 

[Danny]

Thanks everybody for your inputs. I will start putting something together and post back for your reviews.



Thank you,
Danny

 

[Dona]

Danny,

Would you mind sharing your questionnaire db with us?

Thank you.