MS Access Survey Database

[mattster1010]

Morning,

Does anyone know if there is a standard template for the above?

Regards,

Matt

[OBP]

Matt, I have never seen anything, assuming that you are talking about public spending/interest type surveys, each survey is so different that it is hard to imagine how one template would work.
I have assisted with that type of database in the past though.
So what do you need this database to do?

[mattster1010]

OBP,

Its a customer satisfaction database. To capture the happiness of a customer rated from 1 - 5. 1 being good, 5 being bad. Typically looking at around 16 questions involved in the survey.

Do you have any past examples that you have worked on?

Regards,

Matt

[OBP]

I still have one, but it is mostly someone else's work, which wouldn't really be fair to share with you.
But it shouldn't be too difficult to create a quick database to do what you want.
What Outputs do you need out of it?

[mattster1010]

OBP,

Just the ability to report on the feedback from a customer / survey that has been completed on a group of customers.

I would also need the ability to be able to add / delete questions in the database.

Any help you could give would be great!

Regards,

Matt

[OBP]

How much Customer data do you need to collect, the usual name & address etc?

[mattster1010]

The usual name and address will be fine thanks.

[OBP]

Matt, does this need to be Flexible in terms of more than One Survey?

[mattster1010]

Yes it does, it would require multiple surveys.

Thanks again.

[Imdabaum]

My two cents worth...This could be a basic setup of table structures PK/FK on the IDs. Parent form based on the Survey ID, child based on the questions, and then a child to the question form based on available responses.

You can add a higher degree above the survey form with User info.

SurveyTable
SurveyID
SurveyTitle

SurvQuestions
QuestionID
SurveyID
QuestionScript

SurvResponse
QuestionID
ResponseID
ResponseScript

Users
UserID
Name
Address
Email
etc...

UserResponse
UserID
ResponseID
UserSelection

Then when you do reports on the UserResponses you can get user info by UserID, and the Survey info from ResponseID->QuestionID->SurveyTitle

There could be a better way to do it though. I'm suffer from self-doubt at times, and I'm sure there might be a better way to do it, but until then... Good luck.

[OBP]

Imdabaum, that is very much what I have got so far, plus a Standard Response table, where the user can set up Standard responses to all the Survey questions, but they can be entered with different ones if necessary.

[OBP]

This is how far I have got at the moment, I just need to get the Customer's Answers Form created and then look at the output.

PS the Autoexec macro is trying to open the wrong form, it should be the main menu.

[mattster1010]

OK Thanks OBP, great help.

[OBP]

I will post a later version after I have cooked & eaten dinner.

[Imdabaum]

Very cool OBP, it makes me wish I could survey a few people. Enjoy your dinner.

[mattster1010]

Morning OBP,

Did you get a chance to create a final version?

Cheers,

Matt

[OBP]

Matt, it is by no means a final version, but it does do the basics. It will obviously need Formatting, testing and Queries/reports added.
It has got the basic output query that you can use to get the data out.
The Customer Combo on the Survey Customer Responses Tab could do with a "Not in List" function and all the questions for a Survey could be listed (response records created) to speed things up.

[mattster1010]

Thanks very much OBP.

Great effort! I'll work on customising it more.

[mattster1010]

Hi OBP,

I have a few questions regarding the survey database.

When you select a question from the combo box and then populate an answer, the answer only shows in the combo box when the current record is selected. When the next question is populated the answer from the previous question is not displayed in the combo box. Although the value is held in the table correctly.

Is there anyway to list all questions in the survey, rather than selecting each question from the combo box and then selecting an answer and so forth?

Regards,

Matt

[OBP]

Matt, see, I told you it wasn't finished.
Yes you can have it display all the Questions instead of using the combo.