[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

Form structure in a questionaire database

Due to the experts on the website I have changed my structure of my tables for my questionaire database.  Thanks to all the expert for there input. I am new to access so I dont know how to go about making the form for this table.



 I am stuck now.Here is what I have so far.

"tblquestions"
(Column1)  Question                       (Column2) Possible answers        (Column3)Inspectors
          -------------------                         -------------------------              ---------------------------        
How much fuel was in the car?     1/2                                          Rover, Johnson
Did the car drive safely?                  Full                                        Diamond,Jewels
Where did you Park?                        go                                         etc
                                                             no go

Now what I dont understand is how do I Put this information on a form? certain questions need certain drop down  for the answers. I guess this is probably a dumb question but how does each question show up on the form as each indivdual line?  When the information I need is in the rows. I also have memo fields. For a possible answer. How do I put possible answers under each sentence?  Some of the possible answers do not pertain to the question.
0
gigifarrow
Asked:
gigifarrow
  • 5
  • 3
  • 3
4 Solutions
 
NetExpert_plCommented:
I would create a different structure

"tblquestions"
Question_ID    Question                                        Inspectors
1                      How much fuel was in the car?      Rover, Johnson
....

"tblquestionsanswers"
Question_ID     Answer_ID    Answer
1                      1                   1
1                      2                   2
2                      1                   Full

Open in new window


For each question in a form you can create a combo with values from "tblquestionsanswers" maching the question ID.
0
 
gigifarrowAuthor Commented:
Thanks but if the question is in a drop down format how does that go on the form? With out being a dropdown?
0
 
NetExpert_plCommented:
Could you describe exactly what you want the form to look like? Maybe you could create a screenshot or even a drawing.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
gigifarrowAuthor Commented:
for example: this would be the form. but in the tables these question are in the information of the  how do you make the column called question in to a field that is not a drop down?


1.How much fuel was in the car?    
2. Did the car drive safely?              
3.Where did you Park?

In the table this data is in the rows. with the column named questions. when a drag the field onto the table it will just show one question not all. unless I make it a drop down. But I need it to show like this not in a dropdown.
0
 
ChuckVirtuCommented:
Instead of having a table of questions with the answers, create an answer table to store the values ( answers) and a table for each set of possible answers.  For example:

tblAnswer
Field Name      Data Type
ID
Q1                     text
Q2                     text
Q3                     Text
Q4                     text
where Q1 is your first question, etc and "data type" is approprite for the type of answer.

Then create the questiontables:
tblQ1 (how much fuel)
Q1_ID
Q1_Value
in this table, enter the possible answers (full, 1/2, etc)

tblQ2 (inspectors)
Q2_ID
Q2_Value
values are Johnson, smith, etc

Then use the question IDs to associate the values to the base question table.  If you could attach your DB it would be helpful
0
 
gigifarrowAuthor Commented:
Here is an example .
helpwithsurvey.accdb
0
 
gigifarrowAuthor Commented:
I see how to set it up but how do I tranfer it on form? The questions are in rows when I drag the field called Questions. It only shows one question. Not all of them.
0
 
ChuckVirtuCommented:
Take a look at this example....is this the result you are looking for?
helpwithsurvey.accdb
0
 
gigifarrowAuthor Commented:
First thanks for all your time but i guess Im not explaining it right. I have a table. it has a field called questions in that column there are questions written in each row. instead of having a question in every column since i have over 255 questions so i had to put them in one coulmn called questions.

now how do i transfer the questions that are in  the column under a field called questions? in a form with out it being in a drop down. Its like having a drop down but it field in the drop down looks like a single field.  

"tblquestions"
(Column1)  Question                                            
How much fuel was in the car?  
Did the car drive safely?                      now put this in a form but not as a drop down.
Where did you Park?
0
 
NetExpert_plCommented:
If you want all questions in a form, create a continuous form based on the table.

For answers, create a separate table for possible answer and a field in questions table for an answer given. Establish a relationship between "answer given" field and "possible answers" table (see http://support.microsoft.com/kb/304466 or http://msofficeuser.com/pages/access/creating-primary-keys-and-foreign-keys-in-microsoft-access). This will allow you to drag the field into a form and get a combo box with possible answers. A user will use it to answer a question.
0
 
ChuckVirtuCommented:
You can create a table with each record being a question, then add that field to a form with a list box.  That will display all the questions in one field.

What do you plan on doing with them once they are on the form?  It seems that you will want to associate different answers to each question and if so, you will have to support a many to one relationship.  

if you could create a Word doc or a hand skecth of what you would like this form to look like it would be easier to help you with the data model.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now