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?