Research Project: one database or seperate

I'm a bit of an access novice and have a wee question. I'm building a
database to store and analyse questionnaire responses for a research project.
I have 11 separate questionnaires for different sectors of the community and
all the questions are different. What I can't decide is whether these should
all be in the one database (and how to link them if they should) or whether I
should have a separate database for each questionnaire type? The only link
between questionnaires that I can think of could be geographical (e.g.
different questionnaires but they'll all be from Scotland) but I'm not sure
how I would link using that. Any advice very much appreciated!

Cheers
Hannah

Hi Hannah,

All in one database. Here is a nice sample for you, courtesy of Access MVP
Duane Hookom:

http://www.rogersaccesslibrary.com/f...osts.asp?TID=3


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

"Hannah" wrote:

I'm a bit of an access novice and have a wee question. I'm building a
database to store and analyse questionnaire responses for a research project.
I have 11 separate questionnaires for different sectors of the community and
all the questions are different. What I can't decide is whether these should
all be in the one database (and how to link them if they should) or whether I
should have a separate database for each questionnaire type? The only link
between questionnaires that I can think of could be geographical (e.g.
different questionnaires but they'll all be from Scotland) but I'm not sure
how I would link using that. Any advice very much appreciated!

Cheers
Hannah