create a questionaire

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
I'm trying to create a questionaire in Access..however I'm not quite sure how the structure should be...I have a table of 10 different questions with possible responses. Which are yes/no and N/A. But I want the 10 questions to appear on a form as question #1 - #10, all on the on form...as if you're looking at a sheet with check boxes next to the question. I don't want to have to scroll through each question...am I making sense? Does anyone have any suggestions at all on how to proceed??

Thanks,

Dave :rolleyes:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

WillR

Well-known Member
Joined
Feb 18, 2002
Messages
1,143
I guess you'll want to track responder details too?

If so, my thoughts as follows.

2 Tables

tblResponder
responderID (Autonumber - PK)
RfirstName
RSurname

tblQuestions
AnswerID (autonumber PK)
responderID
Question1
Question2
...
Question10

All the Question filelds can have a valid entry of YES/NO/NA

How you set it up on the form could be just Labels containing the Questions & checkboxes / comboboxes to capture the response

To be honest... you needent have the responder table if you don;'t want it - just put the details on the Question table
 

Davers

Well-known Member
Joined
Sep 17, 2002
Messages
1,165
Thanks for the response!!! The thought of using labels for the questions had crossed my mind a day or so ago...I'm not sure what happened to that idea though... :wink: it sort of just fell along the wayside...I'll give your suggestions a shot!!...

wish me luck and thanks again!!

Dave
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,322
Messages
5,769,451
Members
425,548
Latest member
macjagger17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top