Results 1 to 9 of 9

Thread: survey (A2002)

  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    survey (A2002)

    I've been assigned to create a database to store and tabulate survey results. This is a new one for me. I'm looking for a jump start on the project. The table and form structure seem pretty straight forward; it's the calculations I'm wondering about.

    Is there a good resource out there on how to most efficiently handle this piece of the project? I wanted to get some advise from someone who's done this and is happy with the result.

    Seems Excel would handle the calculations better than Access. I've not used the two program interactively so if this is the way to go I'll need to be pointed to a good "how to" source.

    I'm looking for a simple efficient strategy. If you know one, I'd love to learn about it.

    Thanks in advance for your time.

    Elizabeth

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: survey (A2002)

    I hate to disillusion you, but surveys are NOT straightforward, at least not if they're done for maximum flexibility in analyzing the results, and you can't do it that way in Excel either. There have been a number of previous discussions in this forum on surveys and how to construct them, so I'd suggest a Lounge Search to find those previous discussions. If the survey is at all complex or if the analysis is likely to be, then don't get sucked into creating a flat table. It's fast, it's easy, and it's nearly impossible to do any kind of serious analysis on that kind of design.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    Thanks for the heads up. I'll follow up on that lounge search.

    elizabeth

  4. #4
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    I wrote an ASP based 'employee satisfaction' survey. I could send you what I built for it, minus the Memo Field data, if you want. Well, I could post it on the lounge here (I think I can zip it small enough).

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: survey (A2002)

    Take a look at <post#=130331>post 130331</post#> for some ideas, I know it's not s survey but it may help.
    What it effectively does is, once a main record is added the subform is populated with 63 records. These records are then entered by a 1 character keystroke before the cursor moves onto the next record in the subform.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    I'd love to take a look. My ASP is nonexistant, but I've got to start getting a handle on it somewhere...might as well be now.

    esw

  7. #7
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    Actually goofed the live database in getting it setup to send to you. I will try to put it all together this weekend, if not then, I'll do so Monday.

  8. #8
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    <P ID="edit" class=small>(Edited by charlotte on 24-Feb-03 20:59. to activate link)</P>Hi, I'm not sure how you're planning on collecting data for the survey, but if you're planning on doing it over the web, there's a product called Perseus SurveySolutions, which does a pretty good job collecting and analyzing it. (I don't work for Perseus, but some other people in my group at work have used it extensively, so I feel comfortable recommending it.) Without going into detail about how it works, the data is collected over the web using standard HTML forms and perl scripts that they provide (or the data can be entered directly into the software by the survey administrator), and ends up in an Access database. The software has some decent analysis and reporting capabilities built in, and it can dump reports and charts to Excel and PowerPoint. Any additional analysis you want to do can be done by going directly into the database.

    Their web site is http://www.perseus.com . The software costs US $1,000 for advanced survey creation and analysis (multi-page, branching surveys), or $500 for the more basic version (which may well meet your needs). There's a bit of a learning curve to use it (not too bad though), and the HTML pages is creates usually need a bit of "prettying up", but it's fairly powerful software.

    Hope this helps,

    Brent

  9. #9
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: survey (A2002)

    Sorry for the delay, I'll post it tomorrow. It's late, and I just got my DSL working tonight. (I live in Dallas, so the weather this week has put a damper on a lot of plans....so I've been swamped).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •