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!
On Sun, 8 Nov 2009 14:12:01 -0800, hannah <han...@discussions.microsoft.com> 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!
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!
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.
> 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!
> 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.
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.
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:
kenwsheridan<at>yahoo<dot>co<dot>uk
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!
> 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.
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 !!)
|
