Research project: one database or several

I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, farmers etc) and my question
is whether (and how) I put these questionnaires into one database or make a
separate database for each questionnaire type? The only thing the
questionnaires really have in common is country (e.g. pulling up all the
questionnaires relating to Scotland) but I'm not sure how to base a link on
this or whether I should try. Any advice would be very much appreciated!

Cheers
Hannah

On Sun, 8 Nov 2009 14:12:01 -0800, hannah
wrote:

I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, farmers etc) and my question
is whether (and how) I put these questionnaires into one database or make a
separate database for each questionnaire type? The only thing the
questionnaires really have in common is country (e.g. pulling up all the
questionnaires relating to Scotland) but I'm not sure how to base a link on
this or whether I should try. Any advice would be very much appreciated!

Cheers
Hannah

You might want to take a look at Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000'

It allows multiple questionnaires in a single database, which would almost
certainly be your best tack.
--

John W. Vinson [MVP]

Typically you would put all of the records in one database, and add a field
to your table to categorize each record as desired. e.g., a field named
SurveyType could hold values like "government" one record, and "fishermen" in
another record, etc.

The biggest issue at the outset is getting the database "normalized".
Unfortunately is requires some detailed knowledge of what you need to do, and
how you need to use the data to recommend anything specific. Try reading up
on database normalization.
--
Frank H
Rockford, IL


"hannah" wrote:

I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, farmers etc) and my question
is whether (and how) I put these questionnaires into one database or make a
separate database for each questionnaire type? The only thing the
questionnaires really have in common is country (e.g. pulling up all the
questionnaires relating to Scotland) but I'm not sure how to base a link on
this or whether I should try. Any advice would be very much appreciated!

Cheers
Hannah

Hello Hannah,

I provide help with Access, Excel and Word applications. I specialize in
specila projects like yours. I would like to offer to work with you to put
together the database you need. My fee would be nominal. Contact me if you
would like to work together on your project.

Steve



"hannah" wrote in message
...
I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, farmers etc) and my
question
is whether (and how) I put these questionnaires into one database or make
a
separate database for each questionnaire type? The only thing the
questionnaires really have in common is country (e.g. pulling up all the
questionnaires relating to Scotland) but I'm not sure how to base a link
on
this or whether I should try. Any advice would be very much appreciated!

Cheers
Hannah

"Steve" wrote in message
m...
Hello Hannah,

I provide help with Access, Excel and Word applications. I specialize in
specila projects like yours. I would like to offer to work with you to put
together the database you need. My fee would be nominal. Contact me if you
would like to work together on your project.

Steve




These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

-- This post was shortened, not to show a little respect to stevie, but in
response to a public request made by John Vinson. I tend to show stevie as
little respect as possible.

John... Visio MVP

Hannah:

I see our old friend Steve has put in an appearance. I'm sure others will be
commenting on this, but I'm afraid he is notorious for trying to solicit paid
work from unwary participants here. This is completely at variance with the
non-commercial ethos of the newsgroup. Moreover, he has never produced any
evidence that he is able to deliver a database of commercial standard other
than a few effusive but completely unsubstantiated testimonials. When he
does reply to posts with advice rather than seeking paid work, the advice
proffered has never as far as I have seen been of a level beyond the bog-
standard.

As it happens I have recently been looking at a design for a questionnaire
database myself. Having seen requests like yours quite regularly over the
years it occurred to me that one of my applications which I've made available
on line for some years would, if modified, provide the basis for such a
database. In the context of your current request what I have in mind would
enable all of your questionnaires to be designed and held in a single
database, with the choice of which to use being via an opening menu. I'd be
more than happy to send you a copy once I have it in a usable form, and I
stress this would be completely free of charge! At present I have the
'logical model' worked out, i.e. the tables and the relationships between
them, so its now a question of putting the interface together, which I should
have, at least in a form ready for testing, within the next week.

If you'd like me to send you a copy once its available drop me a line at:

kenwsheridanatyahoodotcodotuk

My motives are not entirely altruistic of course. It would be very useful to
me for someone to assess the suitability of the file against a real world
research requirement and make comments and suggestions.

Ken Sheridan
Stafford, England

hannah wrote:
I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.

I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, farmers etc) and my question
is whether (and how) I put these questionnaires into one database or make a
separate database for each questionnaire type? The only thing the
questionnaires really have in common is country (e.g. pulling up all the
questionnaires relating to Scotland) but I'm not sure how to base a link on
this or whether I should try. Any advice would be very much appreciated!

Cheers
Hannah

--
Message posted via http://www.accessmonster.com

"Steve" schreef in bericht
m...
Hello Hannah,

I provide help with Access, Excel and Word applications. I specialize in specila
projects like yours. I would like to offer to work with you to put together the database
you need. My fee would be nominal. Contact me if you would like to work together on your
project.

Steve




You just don't get it ???

Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 10.500 pageloads... it's
a shame !!)

Arno R