Survey in microsoft access

Yes No. Sorry this didn't help. Thanks for your feedback. Thanks but this didn't seem to get to what I want. I'll just try to lay it out how I want and if someone could walk me through how to build it that would be great. I would like the form to look something like this the second column is where you would enter in you data.

Is there a way to enter in data once to a form and have it divvy up among their respective tables? A survey database has a very specific structure and you are not using it. Using fields to stand for each question is not correct or normalized. The general data entry structure is a main form bound to tblResponse where the user selects the respondent etc. Details required : characters remaining Cancel Submit 2 people found this reply helpful. Thank you for your detailed responses.

As I suspected the design of my database is incorrect. I am going to start building as you suggested above but before I do, I have a couple of questions, if I set up my structure like above, can I. Create a form such that data can efficiencly be entered in. Can you set up the data via a query or maybe something else so that the data will be in this structure.

The reason for this is that we export this data in this fashion into another software that does the analyzing for us. With the model I described users will not have to. The relationship between questions and surveys is predefined by the SurveyQuestions table populated by you, of which the users will not even be aware.

The model as I described it allows for complete freedom of entry of answers, with no need to select from a list. While this is appropriate in some questionnaire contexts, it does not provide for easy analysis of the data as there is no set of fixed values on which the query the database.

I'd advise you consider this issue carefully. At the very least users should be constrained to a fixed set of answers by an enforced relationship with an answers table, even if you do not use a combo box for data entry, though I find it difficult to see any cogent rationale for your objection to the latter as expressed in your original post.

Yes, by joining multiple instances of the responses table, restricting each instance to one question. Details required : characters remaining Cancel Submit. DateEntered And a subform, in continuous forms view, based on a table structured along these lines: PatientSurveyResponses RoundNumber FK SurveyID FK QuestionID FK Answer The primary key of this table would be a composite one of the first four columns.

The other referenced tables in the model would be Surveys, Questions and Patients. I have set up their respective relationships and now am attempting to create the form but am not having much luck. Right now in the design form I put in all the fields in the PatientSurvey table. Next I need to put in the questions but I am unsure where to go from here. It would be great if you could give me a walk through.

No, this is a foreign key referencing the primary key of Patients see 4 below. You yourself said at the start that the primary key would be a composite one of PatientID and RoundNumber, and I've worked on this basis, i. PatientID in this case would not be an autonumber, however. Again no, for the same reasons. You can have table exactly like that provided that each question can apply to one survey only, in which case you would not need a separate Questions table. In fact you could rename this table Questions and QuestionID would be its primary key.

For our example, imagine you come up with questions like these:. After planning the survey, you can create it. You can start from a normal table in Design View. Although you can use a long name for any question, you should use short ones.

The first question can be named Question1, the second question can be named Question2, and so on. To give an indication of what a question is, you can change its Caption in the Design View accordingly. If you are equipped with the paper you used to plan the survey, which you should be, you can omit the captions as they may appear too long.

To provide the various answers for each question, once again you have many options. For an advanced survey, you can first create a table for each question, then link all question-tables to a central table. The easiest alternative is to use the Lookup Wizard and its second radio button to create the answers. Kind regards, Fish. Hi Fish, There are 80 businesses to be surveyed and they will be visited annually. Each OHM is responsible for a group of businesses in the network maybe each.

So I assumed they would need their own table but perhaps having their contact information I only need to capture their name as a lookup table in tblProperties would be preferred? Not sure - I'm very new to Access and will need to approach this step by step. I appreciate your guidance, Tux. Hi, Tux. It is still somewhat unclear how [tblOhm] could be related to whatever table since I could not figure out how what you've posted could define your database business logic.

Please explain what is the relation between businesses and surveys or surveyors or whatever else in your database. FishVal Sorry for the confusion Fish but thanks for sticking with me. Figure [tblOhm] is a list of individuals called OHM's that are independent consultants working with the businesses. Same for surveyors, which are listed in [tblSurveyBy]. I wish to track survey responses by surveyor and OHM, among others.

Since the two groups, OHM's and surveyors are not directly tied to the businesses shown in [tblProperties], I thought I had to place these groups in separate tables. Fish - any additional thoughts on this? Maybe I should simplify it, get it working then expand from there. Can anyone else help with this? I think I started off too complicated so maybe I need to break this down a bit. I'll resurrect this thread to say that I have a working example of the survey database that works quite well, but would like to add some additional functionality requiring coding that is way beyond my abilities.

I don't have much free time and would rather hire someone here to just get 'er done. If interested, please contact me. Post Reply. Similar topics PHP. Microsoft SQL Server. DB design question - survey system. MS Access Go to newly added record from form2 to form 1.

Survey databases and distribution to interviewers.