Data suitable for Access?

[Maurice]

I have nearly 100 responses to a questionaire and would like to organize it.
Some information are typical fields e.g. name, address, etc. The rest are
responses to the questions. The question types are: y/n; likert scale 1-5;
multiple choice; the remainder are ad lib. Is access the most suitable for
this task and what is the best way to structure this so that I can do the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions the same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Douglas J Steele]

For a great example of how a questionaire should be designed, take a look at
Duane Hookom's "At Your Survey"
http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

 

[Maurice]

Much thanks for the timely reply. We intend to use it in the future but we
already have responses to a previously distributed questionaire. The task is
to organize the responses. Can an Access database be designed to organize
the collected data?

For a great example of how a questionaire should be designed, take a look at
Duane Hookom's "At Your Survey"
http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have nearly 100 responses to a questionaire and would like to organize it.
Some information are typical fields e.g. name, address, etc. The rest are
responses to the questions. The question types are: y/n; likert scale 1-5;
multiple choice; the remainder are ad lib. Is access the most suitable for
this task and what is the best way to structure this so that I can do the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions the same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Douglas J Steele]

Sure it can. How have you got the results now?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Much thanks for the timely reply. We intend to use it in the future but we
already have responses to a previously distributed questionaire. The task is
to organize the responses. Can an Access database be designed to organize
the collected data?

For a great example of how a questionaire should be designed, take a look at
Duane Hookom's "At Your Survey"
http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have nearly 100 responses to a questionaire and would like to

organize
it.

Some information are typical fields e.g. name, address, etc. The rest are
responses to the questions. The question types are: y/n; likert scale 1-5;
multiple choice; the remainder are ad lib. Is access the most

suitable
for

this task and what is the best way to structure this so that I can do the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions the same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Maurice]

Greetings:

They are at my office but I have all of the responses.

Sure it can. How have you got the results now?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Much thanks for the timely reply. We intend to use it in the future but we
already have responses to a previously distributed questionaire. The task is
to organize the responses. Can an Access database be designed to organize
the collected data?

For a great example of how a questionaire should be designed, take a look at
Duane Hookom's "At Your Survey"
http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have nearly 100 responses to a questionaire and would like to organize
it.
Some information are typical fields e.g. name, address, etc. The rest are
responses to the questions. The question types are: y/n; likert scale
1-5;
multiple choice; the remainder are ad lib. Is access the most suitable
for
this task and what is the best way to structure this so that I can do the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions the same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Douglas J. Steele]

Yeah, but how? On paper? Electronically?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Greetings:

They are at my office but I have all of the responses.

Sure it can. How have you got the results now?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Much thanks for the timely reply. We intend to use it in the future
but we
already have responses to a previously distributed questionaire. The
task is
to organize the responses. Can an Access database be designed to
organize
the collected data?


:

For a great example of how a questionaire should be designed, take a look at
Duane Hookom's "At Your Survey"
http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have nearly 100 responses to a questionaire and would like to organize
it.
Some information are typical fields e.g. name, address, etc. The
rest are
responses to the questions. The question types are: y/n; likert
scale
1-5;
multiple choice; the remainder are ad lib. Is access the most suitable
for
this task and what is the best way to structure this so that I can
do the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions
the same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Maurice]

The responses either text in an email or text in a word document.

Yeah, but how? On paper? Electronically?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Greetings:

They are at my office but I have all of the responses.

Sure it can. How have you got the results now?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Much thanks for the timely reply. We intend to use it in the future
but
we
already have responses to a previously distributed questionaire. The
task
is
to organize the responses. Can an Access database be designed to
organize
the collected data?


:

For a great example of how a questionaire should be designed, take a
look at
Duane Hookom's "At Your Survey"

http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have nearly 100 responses to a questionaire and would like to
organize
it.
Some information are typical fields e.g. name, address, etc. The
rest
are
responses to the questions. The question types are: y/n; likert
scale
1-5;
multiple choice; the remainder are ad lib. Is access the most
suitable
for
this task and what is the best way to structure this so that I can
do
the
following:
1- query a respondents answers
2- query the number respondents who answered a question/questions
the
same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.

 

[Douglas J. Steele]

Sounds as though you're going to have to transcribe the data, then. I'd
recommend using At Your Survey now then.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

The responses either text in an email or text in a word document.

Yeah, but how? On paper? Electronically?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Greetings:

They are at my office but I have all of the responses.


:

Sure it can. How have you got the results now?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Much thanks for the timely reply. We intend to use it in the future
but
we
already have responses to a previously distributed questionaire.
The
task
is
to organize the responses. Can an Access database be designed to
organize
the collected data?


:

For a great example of how a questionaire should be designed, take
a
look at
Duane Hookom's "At Your Survey"

http://rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


I have nearly 100 responses to a questionaire and would like to
organize
it.
Some information are typical fields e.g. name, address, etc.
The
rest
are
responses to the questions. The question types are: y/n; likert
scale
1-5;
multiple choice; the remainder are ad lib. Is access the most
suitable
for
this task and what is the best way to structure this so that I
can
do
the
following:
1- query a respondents answers
2- query the number respondents who answered a
question/questions
the
same
way [when applicable]
3- [optional] generate percentages of responses
4- [optional] 'Lock' the responses so they cannot be altered

Much thanks for support and guidance on this issue.