Access database design question

Posted on 2012-09-06
Last Modified: 2012-09-08
Hello.  This is just a general concept question. Trying to see if anyone else out there has attempted something similar and how they handled it.

I'm looking to create a questionnaire database in Access that will be sent to recipients. They will be required to answer the questions (by entering data in textboxes or whatever on database forms) and send the database back to me.  What I'm looking to do is try as best as possible to prevent them from returning the database with some questions unanswered. I want to require all questions to be answered. Any thoughts on how to accomplish this?

I do want them to be able to skip over questions if they need to and return to them at a later time or date. So I definitely don't want something where they can't advance to the next question until the current one is answered.  I was thinking possibly that a WORD document with the required answers could be generated and only generated once all questions are answered. However, I ultimately need the data in a database, so I'd have to wind up transferring the data from the WORD documents back into an Access database.  Possibly have Access create a new database once all questions have been answered and have the recipients return the newly created databases?  Or am I way off course? Thanks.
Question by:dbfromnewjersey
    LVL 19

    Assisted Solution

    I'm pretty much an amateur at Access, but will toss in some comments nonetheless.

    I would consider keeping a table for the questionnaire that has a boolean for each question storing whether or not the question has been answered.  Be careful to clear it from Yes to No if someone goes back and deletes an answer.

    When the user exits the questionnaire, you could check the entries in the table and prompt them accordingly (Questionnaire is not completed, finish now or later?; questionnaire is completed, would you like to send the results?).

    The table would allow you to give the user the option of going through only the unanswered questions.

    I would think it best to send the results back as a small Access database.
    LVL 39

    Accepted Solution

    Test sample. Results will be sent you as xls file.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now