smart Z
asked on
simple survey questionaire
Hi there,
I need a very simple survey designed in MS access or HTML.
The first line should have the First name and Last name
Right below it I will need questions like.
1) Are you able to access the application? Yes or NO ( check boxes)
2) Are you able to open your files? Yes or NO ( check boxes)
I want them to answer these question and they respond to with their answers via email.
Many thanks inadvance.
I need a very simple survey designed in MS access or HTML.
The first line should have the First name and Last name
Right below it I will need questions like.
1) Are you able to access the application? Yes or NO ( check boxes)
2) Are you able to open your files? Yes or NO ( check boxes)
I want them to answer these question and they respond to with their answers via email.
Many thanks inadvance.
ASKER
Your response is great but I am really struggling to create one as I have never used MS access.
Also the users who are answering the questions do not have access to MS access. Do they need access to MS access.
Also the users who are answering the questions do not have access to MS access. Do they need access to MS access.
it is all going to depend on your setup. are your users all using the same network? if so then you can create a database, place on the network share then write code using msacess (front end - look at splitting msaccess database), or vb/dotnet or some other language.
You can even do it in html but would need access to the db.
let me come up with a simple html form to email submit example
You can even do it in html but would need access to the db.
let me come up with a simple html form to email submit example
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
simple database scenario - users need the ability to run msaccess
you create one db which contains your tables (backend db)
you create another db which links the tables to the backend db (called frontend)
this frontend is distributed to your users
alt version
you write a program using vb for example, you can connect to access and record answers using the draft table design
alt version 2
create a web page that connects to your db and records answers
all of the above is lot more work though
you create one db which contains your tables (backend db)
you create another db which links the tables to the backend db (called frontend)
this frontend is distributed to your users
alt version
you write a program using vb for example, you can connect to access and record answers using the draft table design
alt version 2
create a web page that connects to your db and records answers
all of the above is lot more work though
smartmanwin:
The link below might be of help to you. It has sample that you can play with. Once you like it, you may only change the fields.
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=618891E8-7145-44C8-9E40-82218B1E8DF7&displaylang=en
Sincerely,
Ed
The link below might be of help to you. It has sample that you can play with. Once you like it, you may only change the fields.
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=618891E8-7145-44C8-9E40-82218B1E8DF7&displaylang=en
Sincerely,
Ed
You might also want to take a look at this survey database:
http://www.rogersaccesslibrary.com/forum/at-your-survey_topic3.html
http://www.rogersaccesslibrary.com/forum/at-your-survey_topic3.html
ASKER
Thanks guys I will look into it and get back to you.
so first thing you need to do is come up with a table design
something like this maybe
table 1 : Person
PersonID, First Name, Last Name
table 2 : Questions
Queston ID
Question Text
table 3 : Answers
Answer ID
Question ID
Answer
Person ID
the above is very basic
first table to hold a persons name
second table to hold your list of questions
and the third table to record the answers. it links the question table and person table
So now what you can do is create a form which prompts for the name then list the questions
I am assuming all responses are yes/no based on the example given
once they click submit you can save these to the table
The above is a flexible solution allowing you to add, delete or modify question
With it saved in the db, you dont need to email if you have access to the db.
HTML VERSION
You can create a simple web page with fixed text. On form submit you can send the responses by email