Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    31

    Unanswered: Microsoft Access 2010 Designing A robust Questionnaire Help Request

    Hi All

    I am trying to design a questionnaire using Microsoft access database 2010 which should be robust and user friendly. I am thinking of three tables
    |Question | Answer | Customer |

    Procedure
    Customer are give a questionnaire and they answer all the questions on questionnaire. Customer Table have two unique id which is 1. customer_id 2. PIN no.
    These customers who don't have Pin No which is unique will use customer_id which is allocated automatically on the Customer table. However in future they will be issued with a Pin No which will be unique .
    The database should be able to give various reports on questions answered.
    Also it should be easy to update questionnaire.

    Any ideas and examples on the best way to build a robust and user friendly Access Database Questionnaire will be appreciated.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Duane Hookum, Microsoft MVP, has an excellent example here that he offers free for download:

    At Your Survey Database

    He's fine with you stealing/using any bits and pieces, as you will, simply asking that you don't merely take the entire thing and distribute it as your own!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2013
    Posts
    31
    Thanks so much this is a good starting point of undestanding what need to be done. Much appreciated.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Good luck with your project!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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