Access database design question

Posted on 2012-09-06
Medium Priority
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 22

Assisted Solution

CompProbSolv earned 200 total points
ID: 38374778
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 40

Accepted Solution

als315 earned 1800 total points
ID: 38375177
Test sample. Results will be sent you as xls file.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

850 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