I am creating an Access 2000 database with a Web Front end that will
have around 150 questions with 148 questions having just one number
input (which will either be a 1 or a 2 or a 3 or a 4 or a 5).  All 148
questions will be short sentences such as:

Question                                   Choose One Number Rating
1-How would you rate Red Rock1?                  1   2   3   4   5
2-How would you rate Red Rock2?                  1   2   3   4   5
3-How would you rate Red Rock3?                  1   2   3   4   5
4-How would you rate Blue Rock1?                 1   2   3   4   5
5-How would you rate Blue Rock2?                 1   2   3   4   5
6-How would you rate Blue Rock3?                 1   2   3   4   5
etc...

The 6 above examples show just 6 (redRock1, redRock2, redRock3,
blueRock1, blueRock2, blueRock3) out of the 148 fields.

The other two fields will have a 100 character input and 250 character
max input.

I will have three other tables similiar to this table (with each table
having 150 fields (148 single number input fields and 2 fields limited
text under 250 characters).

There will be around 800 people taking this questionaire survey over a
2 week timeline where it takes around 20 minutes to complete after
which time the user will submit the information into the 4 tables.


Please advise if Access can it handle 150 fields per table and
everything I want to do?

<teser3@hotmail.com> wrote in message 
news:1164936290.128322.85090@n67g2000cwd.googlegroups.com...
>I am creating an Access 2000 database with a Web Front end that will
> have around 150 questions with 148 questions having just one number
> input (which will either be a 1 or a 2 or a 3 or a 4 or a 5).  All 148
> questions will be short sentences such as:
>
> Question                                   Choose One Number Rating
> 1-How would you rate Red Rock1?                  1   2   3   4   5
> 2-How would you rate Red Rock2?                  1   2   3   4   5
> 3-How would you rate Red Rock3?                  1   2   3   4   5
> 4-How would you rate Blue Rock1?                 1   2   3   4   5
> 5-How would you rate Blue Rock2?                 1   2   3   4   5
> 6-How would you rate Blue Rock3?                 1   2   3   4   5
> etc...
>
> The 6 above examples show just 6 (redRock1, redRock2, redRock3,
> blueRock1, blueRock2, blueRock3) out of the 148 fields.
>
> The other two fields will have a 100 character input and 250 character
> max input.
>
> I will have three other tables similiar to this table (with each table
> having 150 fields (148 single number input fields and 2 fields limited
> text under 250 characters).
>
> There will be around 800 people taking this questionaire survey over a
> 2 week timeline where it takes around 20 minutes to complete after
> which time the user will submit the information into the 4 tables.
>
>
> Please advise if Access can it handle 150 fields per table and
> everything I want to do?

Better to structure your tables so each question is a ROW rather than a COLUMN. 
It does make the interface a bit more challenging, but that design is a LOT more 
flexible.

-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com 

> Better to structure your tables so each question is a ROW rather than a COLUMN.
> It does make the interface a bit more challenging, but that design is a LOT more
> flexible.
>
Thanks,

Please advise what you mean by the design being more flexible if I keep
my table columns at 150 fields?
I actually have 3 tables with 150 fields in each one and one
Demographic table that ties each survey with a Demographic id.

I currently have my web Front end interface working very well with the
150 wide one table insert on my Access 2000 database.    The records
currently insert very quickly  but still wondering what issues I will
have if I keep the 3 tables at 150 column wide??   I am looking at
about 800 Survey inputs for this database over a 2 week period and then
close the survey and start doing reports off the database results.

teser3@hotmail.com wrote in
news:1165162998.643002.169070@73g2000cwn.googlegroups.com: 

>> Better to structure your tables so each question is a ROW
>> rather than a COLUMN. It does make the interface a bit more
>> challenging, but that design is a LOT more flexible.
>>
> Thanks,
> 
> Please advise what you mean by the design being more flexible
> if I keep my table columns at 150 fields?
> I actually have 3 tables with 150 fields in each one and one
> Demographic table that ties each survey with a Demographic id.

You want a survey results table with 5 columns
SurVeyID,RespondentID,QuestionID,AnswerNo and AnswerText 

The answers each get their own row.

To go with that, you will need a few other small tables

Survey: which contains an ID, and description about what the 
survey is on, customer.,dates etc.

Respondent: again an ID, respondent Info as required.

Questions: this has SurveyId, QuestionID and QuestionText.One 
question per row.

> 
> I currently have my web Front end interface working very well
> with the 150 wide one table insert on my Access 2000 database.
>    The records currently insert very quickly  but still
> wondering what issues I will have if I keep the 3 tables at
> 150 column wide??   I am looking at about 800 Survey inputs
> for this database over a 2 week period and then close the
> survey and start doing reports off the database results. 
> 



-- 
Bob Quintal

PA is y I've altered my email address.

-- 
Posted via a free Usenet account from http://www.teranews.com