Sample-->Responders-->Aggregate Responders

[JuleighGee]

Good morning,

I am VERY new to access, but well versed in the analyses of data (statistics). I'm in the process of putting our data warehousing into access, instead of using a flat file. Here is my question. We have the following files that I need to link.

1. Sample File (this file is for participants who are ASKED to complete the survey).
2. Responder File (this file is for participants who have completed the questionnaire.
3. Aggregate File. (this file is the aggregate. For example, we could have 5 responders surveyed regarding 1 software implementation for "ABC Bank") Thus we "roll-up" the results and say, ABC BANK had a satisfaction score of 80.3 based on 5 responders... They use a different Unique ID.

So the Sample File and Responder File use the same ID #'s -- however, since the responder file is only those clients who participated, when I try to link the relationship I get an error message... ? I think because the Sample file contains ID#'s that are not in the responder file.

Any help would be appreciated. I know I will love access once I learn it well, but for now I am trying to hone in on the table set-up and linkages b/c I'm seeing how important it is for queries/reports/forms. In the meantime I will be nose deep in the "missing manual" for access 2010. Thank you in advance!

Julie

 

[G37Sam]

Looks like you need a back end/front end model. Are your surveys done internally (employees in your LAN) or externally?

 

[JuleighGee]

external. we download the data from the survey provider in an excel form. What i'm trying to do is put the survey data into access in a way that makes sense (no duplicate info, and linked correctly).

 

[G37Sam]

I see, you can do two things

1) Use sharepoint or any other DB host to host your back end on. All your surveys could be linked in it.

2) Keep your backend local to you and have some sort of import feature, create a template DB to distribute as your survey

 

[JuleighGee]

Thank you. I think I should have been more explicit... where I said "files" I means Tables.... I have these three tables in access.... and I am having trouble defining the correct relationship between them. I'm not really concerned with how the survey is administered, ect. I have the survey data that I need to put into (at least) these three tables in Access. Thanks.