Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Question setting up tables for a survey

0 views
Skip to first unread message

forest8

unread,
Dec 21, 2009, 10:06:02 PM12/21/09
to
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]

unread,
Dec 21, 2009, 10:33:39 PM12/21/09
to
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.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"forest8" <for...@discussions.microsoft.com> wrote in message
news:254A0B6E-02F2-4129...@microsoft.com...

Duane Hookom

unread,
Dec 21, 2009, 10:47:01 PM12/21/09
to
Use my 2000 version at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3.

--
Duane Hookom
Microsoft Access MVP

forest8

unread,
Dec 21, 2009, 11:55:01 PM12/21/09
to
Two questions please:

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

Thank you again.

"Arvin Meyer [MVP]" wrote:

> .
>

Duane Hookom

unread,
Dec 23, 2009, 10:39:01 AM12/23/09
to
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 ;-)

--
Duane Hookom
Microsoft Access MVP

0 new messages