Results 1 to 3 of 3
  1. #1
    Ant_Snell is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    93

    Self-build Questionnaire design

    I would like to incorporate a self-build questionnaire if in by DB that works in a similar way as crating a Google form, rather than creating a hard coded questionnaire that needs that needs re-design every time the user thinks of a new question.



    So I am thinking of building:

    Tbl_Questionnaire containing ID, QuestionnaireName, Date Completed etc.
    Tbl_Questions containing ID, question, Question type, etc.
    Tbl_answers containing ID, users answers, etc.

    One to many relationship from questionnaire to questions

    Maybe (but not sure) one to one relationship from questions to answers

    What I am mainly unsure about is the question data type, it could be that a question requires a short text, long text, radio button, multi chose options, date, number etc. response. Obviously if I was hard coding the questionnaire, I would select the data type for each question but how would I build a DB that allows the user to create their own questionnaire then select a potentially different data type for each question without them accessing the design mode of Access?

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    10,502
    Some answer types can be 'faked'. For example you can use a textbox as a checkbox or radio button (or even a smiley face), just a matter of choosing the right font. doubt you will need a long text for a questionaire - just limit responses to 255 char. Not sure about multiple choice, but can be handled with appropriate table design.

    Example of using textbox as checkbox or radio button here
    https://www.access-programmers.co.uk...eckbox.305659/

    then use code to dictate the way a textbox appears based on question type

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    11,365
    Any of those answer types could be stored in a short text field. Whether or not this would cause any issues I can't say. F'rinstance, if sorting, 1 comes before 11 but 2 comes after 11. Doing math would likely work on text that looks like numbers but not on text (alpha). Not sure what you mean by multiple choice/chose though. If that's choosing one option from a group, the chosen value could still be text data type. If issues arise, likely conversion functions would handle the problem.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 18
    Last Post: 12-04-2017, 05:25 PM
  2. Replies: 8
    Last Post: 02-25-2016, 10:20 AM
  3. Questionnaire Database
    By phool4fool in forum Forms
    Replies: 2
    Last Post: 12-16-2012, 07:40 PM
  4. Questionnaire Database
    By phool4fool in forum Access
    Replies: 1
    Last Post: 12-13-2012, 04:13 PM
  5. Questionnaire DB from Scratch
    By jomby in forum Database Design
    Replies: 4
    Last Post: 05-18-2012, 01:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums