A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

create/design response categories for questionaire



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2006, 03:16 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default create/design response categories for questionaire

How do i set up response categories for my questionaire in microsoft access
program? I have made two tables for pre & post questionaire but i am
struggling with how to create response categories for respondents answers. It
may not be possible. Help!!!!
  #2  
Old April 24th, 2006, 03:20 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default create/design response categories for questionaire

What are "response categories"? How are your tables structured? Have you
normalized your tables or is each question a field in your table?
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
How do i set up response categories for my questionaire in microsoft
access
program? I have made two tables for pre & post questionaire but i am
struggling with how to create response categories for respondents answers.
It
may not be possible. Help!!!!



  #3  
Old April 24th, 2006, 03:35 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default create/design response categories for questionaire

each question or comment is a field in my table. logically, i could just plug
in each response to the question in the appropriate field. each respondent
has an identifiying number. what does it mean to normalize tables?

"Duane Hookom" wrote:

What are "response categories"? How are your tables structured? Have you
normalized your tables or is each question a field in your table?
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
How do i set up response categories for my questionaire in microsoft
access
program? I have made two tables for pre & post questionaire but i am
struggling with how to create response categories for respondents answers.
It
may not be possible. Help!!!!




  #4  
Old April 24th, 2006, 04:18 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default create/design response categories for questionaire

There is a sample/demo of a normalized survey/questionaire "At Your Survey"
available for download at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

At Your Survey allows you to create, edit, and report survey information
generally without modifying a table, form, query, or report. Questions and
responses are records in tables rather than fields of records.

To find out more information on normalization and table structures, check
out the links on Jeff Conrad's site
http://home.bendbroadband.com/conrad...abaseDesign101.
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
each question or comment is a field in my table. logically, i could just
plug
in each response to the question in the appropriate field. each
respondent
has an identifiying number. what does it mean to normalize tables?

"Duane Hookom" wrote:

What are "response categories"? How are your tables structured? Have you
normalized your tables or is each question a field in your table?
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
How do i set up response categories for my questionaire in microsoft
access
program? I have made two tables for pre & post questionaire but i am
struggling with how to create response categories for respondents
answers.
It
may not be possible. Help!!!!






  #5  
Old April 24th, 2006, 04:28 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default create/design response categories for questionaire

thank you.

"Duane Hookom" wrote:

There is a sample/demo of a normalized survey/questionaire "At Your Survey"
available for download at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

At Your Survey allows you to create, edit, and report survey information
generally without modifying a table, form, query, or report. Questions and
responses are records in tables rather than fields of records.

To find out more information on normalization and table structures, check
out the links on Jeff Conrad's site
http://home.bendbroadband.com/conrad...abaseDesign101.
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
each question or comment is a field in my table. logically, i could just
plug
in each response to the question in the appropriate field. each
respondent
has an identifiying number. what does it mean to normalize tables?

"Duane Hookom" wrote:

What are "response categories"? How are your tables structured? Have you
normalized your tables or is each question a field in your table?
--
Duane Hookom
MS Access MVP

"Di" wrote in message
...
How do i set up response categories for my questionaire in microsoft
access
program? I have made two tables for pre & post questionaire but i am
struggling with how to create response categories for respondents
answers.
It
may not be possible. Help!!!!






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why doesn't contact categories work properly? webcpa Contacts 1 January 3rd, 2006 10:08 PM
Assigning categories to multiple contacts Keith Korb Contacts 1 June 4th, 2004 04:51 PM
Contact categories data blank - mismapping? Peter Lunn Contacts 1 May 18th, 2004 12:13 AM
Suppressing categories with 0 values Confusious Charts and Charting 1 May 16th, 2004 09:03 AM


All times are GMT +1. The time now is 11:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.