Question Designing a flowing Questionaire

[Elder Drake]

I have a basic understanding of Access and intermediate skills with Excel but I am running into a problem designing a simple flowing questionnaire. It is my hope that the community can point me in the right direction as all my searches thus far have not yielded the best results.

I am using Access 2013 and I would like to create a questionnaire that flows from one question to the other. Each question would have variables or arguments to move that flowing question to the next part of it until it ends. To be more specific an example would be:

"Do you have children?"
-if yes then "How Many Children do you have?"
-then prompt for "Please name your children" based upon the numerical answer
-end this question and move onto the next flowing question

I know this is basic stuff but I am rusty to say the least. Qualtrics was the closest I could find to having a setup for a flowing survey but I simply can not afford that and must do it myself. I know I will be doing a LOT of brushing up but I would appreciate any pointers in a good direction to start. I do not need a full run down of every aspect of Access but simply an understanding of how to achieve and realize how to properly create and if/then sort of series of questions like the example I listed above. I am new to the site and I know I dealing with professionals so I hope I do not sound like an idiot. A look at a template or existing flowing questionnaire like this would also be great as I could simply learn from that myself.

Thank you for your time and in advance for any help and pointers.

 

[spikepl]

You do know that you can very simply create questionaires, also with branching, in Google docs?

 

[JLCantara]

It's not that a basic problem since out of 107 pers. who visited your post, no one proposed a solution.

1 - You need 2 tables: one for the Questions and one for the SubQuestions, linked to Questions.

2 - Make sure that the records are numbered so that they can be presented in proper order.

3 - Create frmQuestions and frmSubQuestions, a subform of the main form; it is normaly not visible except when an answer to a question calls for subquestions.

Good luck, JLC.