Question setting up tables for a survey

[forest8]

Hello

What is the best way to create tables for a survey. I have inherited a
survey (in excel). I need to get it into Access. Unfortunately, there are
more than 255 fields (more like 400). I've separated the survey into 6 tables.

The way my tables work, the ID is an autonumber. The next column is the
survey number (since this cannot be duplicated). The student numbers are
individual. The following can be duplicated: Date of Birth, Teacher name,
Maiden name, Entry date.

How do I set up the relationship so that when someone enters new data in
that the tables are linked?

There is no guarantee that whoever enters the data will not abandon data
entry at any point during the data input.


Also, I am using Access 2007. Which of the following links should I be using
if I wanted to use if I wanted to use Duane Hookom's "At Your Survey":

http://tinyurl.com/4qtsz

http://tinyurl.com/2prud


Thank you for your help in this matter.

 

[Arvin Meyer [MVP]]

The Access 2K is the closest one. It creates an MDB file, which will run in
Access 2007. If you are using the new ACCDB format, you will need to convert
Duane's file to that format first.

 

[Duane Hookom]

Use my 2000 version at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3.

 

[forest8]

Two questions please:

1. How would I convert the file?
2. Can I incorporate this into an existing database?

Thank you again.

 

[Duane Hookom]

There should be an option to convert somewhere in the ribbon.

You can use "At Your Survey" for your own internal business needs. You may
not include it in "contracted" work without contacting me. In other words, if
you plan to make money from my work, I should get a cut ;-)