If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
database surveys?
On Tue, 5 Dec 2006 08:09:00 -0800, Shannon
wrote: What a great thread; full of adventure, good answers and danger! Chinda D-your answer was understandable. I have some questions for you. First, though, I must ask about Duane H's software. It seems you have to download it and run it which seems scary to me when I don't know what it is. Is it a survey to mimic? Is it a wizard? There's a zip option. Will my computer explode when I unzip it? DH's software may be the best route, but not without answers to the previous questions. Just want to chime in as an external observer. Duane Hookum's "At Your Survey" download is just an Access 2000 format .mdb file. There's no executable, no program, just a database. As he says, it's a properly normalized *example* of how a survey can be set up; it's excellent at that, and quite good enough to use on its own if you're comfortable with using Access; even more so if you're comfortable with *developing* in Access and can customize it to your specific needs. As Duane says, if you're totally new to Access it may be a lot of effort to get running with it, and another tool might be more appropriate. John W. Vinson[MVP] |
#12
|
|||
|
|||
database surveys?
Thanks. I didn't mean to put down your demo. It is very nice. Is there a
way to look at the tables? Maybe I can figure it out. There's a table for surveys, a table for the filled out surveys, a table for questions, and tables for responses. This may be over my head, as I work on Access about once every two years. I still have question. On a survey I'm practicing on, I have one question and five possible responses. The question is in a table, but when I choose the Lookup Wizard to point to the table of responses, it changes the name of the question to ID and doesn't show the available responses. Since I finished the 'shuddering' survey, I have time to mess around, experimenting with the help I find from y'all. Any suggestions? "Duane Hookom" wrote: My "At Your Survey" demo found at Roger Carlson's site http://www.rogersaccesslibrary.com/O...p#Hookom,Duane will not blow up anything. It doesn't use one field per question (shudder...) but rather is normalized to allow you to create new surveys and questions without modifying anything. I know at least church in Minnesota that used AYS to survey their membership. There are some sample reports in the demo that calculate percents and even display pie charts for each statistical question. At Your Survey is not built for web distribution. You could use the table structure but screens, reports,... would need to be programmed in ASP, ColdFusion, PHP, or other technology. I have given some thought to creating this for web use but haven't found the time. It would probably be created with ASP and SQL Server. If you don't have web experience, you would probably be much better off using one of the many on-line survey providers. -- Duane Hookom MS Access MVP "Shannon" wrote in message ... What a great thread; full of adventure, good answers and danger! Chinda D-your answer was understandable. I have some questions for you. First, though, I must ask about Duane H's software. It seems you have to download it and run it which seems scary to me when I don't know what it is. Is it a survey to mimic? Is it a wizard? There's a zip option. Will my computer explode when I unzip it? DH's software may be the best route, but not without answers to the previous questions. That said, Chinda D-your questions: Are the Lookup Wizard and Combo-Box the same thing? I made a little table of the five responses to choose from, but the Lookup Wiz for the table with the questions doesn't display them, even when put in a form for entry. The survey for this year is complete. I sadly used a field for each question and response combo, for example BeingAMemberOfThisParishHelpsMeToLiveMyFaithStrong lyAgree. I was able to calculate percentages (for the 90 fields) in a query and merge them into a copy of the survey which was...written in Word and mailed by US Post to parishioners. This method will probably change to, or be combined with the parish Web-site which was just invented. I entered the data myself through a form I made with Yes/no fields for each question/answer combo. This is why I have so many related questions for you. Next question: Is it worth writing an Access survey for a web site? Do web sites have their own software for that? Can they even use Access in a web site? Another one: If so, and if I use Combo-Boxes, or Lookup Wizards (please suggest one), can I find the percentages of the results? How would this be done? I'm assuming I would have a table of choices like 'Strongly Agree' and a table of questions like 'Being a member of this parish helps me to live my faith.' The user would simply see a form with check boxes next to each question, just like the dinasour I just wrote. Obviously, I'm not an expert, just a nosey stay at home mom, volunteering. Thanks in advance, Shannon "Chinda D via AccessMonster.com" wrote: You can easily contruct an data entry survey by using combo box, command buttons, and option boxs for multiple questions. I recently did 119 questions with 5 multiple choice each. It took some time but it is possible. If this is for data entrying it is perfect. However, if this survey is going to be distribute to others. You should restrict previous records from showing after it is submitted. In your mircosoft office access help type - how to prevent a form from showing existing records- to find out how. I hope this helps. chinda How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200511/1 |
#13
|
|||
|
|||
database surveys?
You can look at the tables by pressing F11 when the mdb is open or holding
down the shift key when opening. -- Duane Hookom MS Access MVP "Shannon" wrote in message ... Thanks. I didn't mean to put down your demo. It is very nice. Is there a way to look at the tables? Maybe I can figure it out. There's a table for surveys, a table for the filled out surveys, a table for questions, and tables for responses. This may be over my head, as I work on Access about once every two years. I still have question. On a survey I'm practicing on, I have one question and five possible responses. The question is in a table, but when I choose the Lookup Wizard to point to the table of responses, it changes the name of the question to ID and doesn't show the available responses. Since I finished the 'shuddering' survey, I have time to mess around, experimenting with the help I find from y'all. Any suggestions? "Duane Hookom" wrote: My "At Your Survey" demo found at Roger Carlson's site http://www.rogersaccesslibrary.com/O...p#Hookom,Duane will not blow up anything. It doesn't use one field per question (shudder...) but rather is normalized to allow you to create new surveys and questions without modifying anything. I know at least church in Minnesota that used AYS to survey their membership. There are some sample reports in the demo that calculate percents and even display pie charts for each statistical question. At Your Survey is not built for web distribution. You could use the table structure but screens, reports,... would need to be programmed in ASP, ColdFusion, PHP, or other technology. I have given some thought to creating this for web use but haven't found the time. It would probably be created with ASP and SQL Server. If you don't have web experience, you would probably be much better off using one of the many on-line survey providers. -- Duane Hookom MS Access MVP "Shannon" wrote in message ... What a great thread; full of adventure, good answers and danger! Chinda D-your answer was understandable. I have some questions for you. First, though, I must ask about Duane H's software. It seems you have to download it and run it which seems scary to me when I don't know what it is. Is it a survey to mimic? Is it a wizard? There's a zip option. Will my computer explode when I unzip it? DH's software may be the best route, but not without answers to the previous questions. That said, Chinda D-your questions: Are the Lookup Wizard and Combo-Box the same thing? I made a little table of the five responses to choose from, but the Lookup Wiz for the table with the questions doesn't display them, even when put in a form for entry. The survey for this year is complete. I sadly used a field for each question and response combo, for example BeingAMemberOfThisParishHelpsMeToLiveMyFaithStrong lyAgree. I was able to calculate percentages (for the 90 fields) in a query and merge them into a copy of the survey which was...written in Word and mailed by US Post to parishioners. This method will probably change to, or be combined with the parish Web-site which was just invented. I entered the data myself through a form I made with Yes/no fields for each question/answer combo. This is why I have so many related questions for you. Next question: Is it worth writing an Access survey for a web site? Do web sites have their own software for that? Can they even use Access in a web site? Another one: If so, and if I use Combo-Boxes, or Lookup Wizards (please suggest one), can I find the percentages of the results? How would this be done? I'm assuming I would have a table of choices like 'Strongly Agree' and a table of questions like 'Being a member of this parish helps me to live my faith.' The user would simply see a form with check boxes next to each question, just like the dinasour I just wrote. Obviously, I'm not an expert, just a nosey stay at home mom, volunteering. Thanks in advance, Shannon "Chinda D via AccessMonster.com" wrote: You can easily contruct an data entry survey by using combo box, command buttons, and option boxs for multiple questions. I recently did 119 questions with 5 multiple choice each. It took some time but it is possible. If this is for data entrying it is perfect. However, if this survey is going to be distribute to others. You should restrict previous records from showing after it is submitted. In your mircosoft office access help type - how to prevent a form from showing existing records- to find out how. I hope this helps. chinda How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200511/1 |
#14
|
|||
|
|||
database surveys?
I was interested in your response to this question. I am struggling with a
survey that requires some "limit to list" responses, some "choose more than one option", and any combination therein. I'm really having trouble desiging my form. I know that I an use various controls, such as combo box, List box, etc., but have no idea how these relate back to my tables. When I design the form, it doesn't allow me a variety of controls for each question - am basing it on AYS. Thanks. -- Thanks! Dee "Chinda D via AccessMonster.com" wrote: You can easily contruct an data entry survey by using combo box, command buttons, and option boxs for multiple questions. I recently did 119 questions with 5 multiple choice each. It took some time but it is possible. If this is for data entrying it is perfect. However, if this survey is going to be distribute to others. You should restrict previous records from showing after it is submitted. In your mircosoft office access help type - how to prevent a form from showing existing records- to find out how. I hope this helps. chinda How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200511/1 |
#16
|
|||
|
|||
database surveys?
"Steve" schreef in bericht ... AYS is very restrictive! You probably need to relook at the design of your tables. PC Datasheet -- ==Let's ask it the 'nice' way... Would you please, please go away Steve ?? This is to inform 'newbees' here about PCD' Steve: http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...) Until now 3700+ pageloads, 2375+ first-time visitors (these figures are real and rapidly increasing) Why is this ??? Because Steve is the ONLY person here who continues to advertise in the groups. It is not relevant whether he advertised in *this* particular post or not... == We want him to know that these groups are *not* his private hunting grounds! For those who don't like too see all these messages: == Simply killfile 'StopThisAdvertising'. Newbees will still see this warning-message. ArnoR |
#17
|
|||
|
|||
database surveys?
How about posting a freely available database, as Duane has done, if you
have a better idea? "Steve" wrote in message ... AYS is very restrictive! You probably need to relook at the design of your tables. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "dee" wrote in message ... I was interested in your response to this question. I am struggling with a survey that requires some "limit to list" responses, some "choose more than one option", and any combination therein. I'm really having trouble desiging my form. I know that I an use various controls, such as combo box, List box, etc., but have no idea how these relate back to my tables. When I design the form, it doesn't allow me a variety of controls for each question - am basing it on AYS. Thanks. -- Thanks! Dee "Chinda D via AccessMonster.com" wrote: You can easily contruct an data entry survey by using combo box, command buttons, and option boxs for multiple questions. I recently did 119 questions with 5 multiple choice each. It took some time but it is possible. If this is for data entrying it is perfect. However, if this survey is going to be distribute to others. You should restrict previous records from showing after it is submitted. In your mircosoft office access help type - how to prevent a form from showing existing records- to find out how. I hope this helps. chinda How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200511/1 |
#18
|
|||
|
|||
database surveys?
There isn't a frrely available database that fits the mold of the OP's
survey. She needs to relook at the design of her tables. She is stuck on using AYS because Duane told her to. In another post she said "I have searched the newsgroups and looked on the Internet, in addition to reading and working on this for hours and hours and am at a loss." She is going to work hours and hours until she relooks at the design of her tables. Instead of making an offensive remark about my post, why didn't ypu try to help the OP? You are just like John Marshall! Are you an "MVP" too? PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "BruceM" wrote in message ... How about posting a freely available database, as Duane has done, if you have a better idea? "Steve" wrote in message ... AYS is very restrictive! You probably need to relook at the design of your tables. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "dee" wrote in message ... I was interested in your response to this question. I am struggling with a survey that requires some "limit to list" responses, some "choose more than one option", and any combination therein. I'm really having trouble desiging my form. I know that I an use various controls, such as combo box, List box, etc., but have no idea how these relate back to my tables. When I design the form, it doesn't allow me a variety of controls for each question - am basing it on AYS. Thanks. -- Thanks! Dee "Chinda D via AccessMonster.com" wrote: You can easily contruct an data entry survey by using combo box, command buttons, and option boxs for multiple questions. I recently did 119 questions with 5 multiple choice each. It took some time but it is possible. If this is for data entrying it is perfect. However, if this survey is going to be distribute to others. You should restrict previous records from showing after it is submitted. In your mircosoft office access help type - how to prevent a form from showing existing records- to find out how. I hope this helps. chinda How do I set up a database where I may efficiently enter data from a town survey? There may be up to 35 questions, some with multiple answers. Thanks! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200511/1 |
#19
|
|||
|
|||
database surveys?
What was his "offensive" remark?
Was it a variation on that four letter word that you strongly detest? "FREE" Or was it that outrageeous idea that YOU may have a "better idea"? As to being an MVP, he has made several posts that could make him a candidate for an MVP award. You on the other hand have made enough posts to make it very unlikely that you would be considered. The award is given for helping the community, something you can not comprehend. You have proven that helping the community is the furthest thing in your mind. John... Visio MVP "Steve" wrote in message ... Instead of making an offensive remark about my post, why didn't ypu try to help the OP? You are just like John Marshall! Are you an "MVP" too? PC Datasheet "BruceM" wrote in message ... How about posting a freely available database, as Duane has done, if you have a better idea? |
#20
|
|||
|
|||
database surveys?
"Steve" schreef in bericht ... There isn't a frrely available database that fits the mold of the OP's survey. She needs to relook at the design of her tables. She is stuck on using AYS because Duane told her to. In another post she said "I have searched the newsgroups and looked on the Internet, in addition to reading and working on this for hours and hours and am at a loss." She is going to work hours and hours until she relooks at the design of her tables. Instead of making an offensive remark about my post, why didn't ypu try to help the OP? You are just like John Marshall! Are you an "MVP" too? PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Hey Steve, relax !! We are judging (just had a Goons-meeting..), that your situation/reputation is simply *not* improving here in the groups... == Every week lots of pagehits and new first-time visitors at http://home.tiscali.nl/arracom/whoissteve.html == No support for you, no new customers from the groups, no answers here ... == So please don't forget to shut the door behind you !! Are there any *other* options left ??? Well.... you *could* consider to stop advertising here... In that case we *might* even consider to close the website... FYI In case you are interested: Also when you are not advertising we still have lots of pagehits for the website... Even in the year that you had gone... Wow...amazing !! Arno R |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Report based on rst in other database | swedbera | Setting Up & Running Reports | 5 | October 6th, 2005 11:41 AM |
Access can't open database | Scott B | General Discussion | 1 | June 28th, 2005 04:16 PM |
Converting 97 database to 2003 database and implications | John | Database Design | 1 | November 22nd, 2004 05:23 AM |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |