survey db

[gbanks]

I've been asked to make a survey db by someone. I was wondering what is the best way to go about this? The output spread sheet list several questions asked of the user. The user id and questions asked are in columns. So you could have a columns like the user id: date: when was the last time you reaed a book?id you like the book?: Was the book helpful? What type of book was it?. These are listed in many rows one for each survey asked. Is my best bet to just make each column a field name in a table and build off of that? Some of the question asked are very length? I can have the spread sheet altered to column names that are more relivant and shorted so when I import into access and populate them into a table it will be easier to follow. Just looking for a little guidance. All thoughts are appreciated. Thanks...

 

[stepdown]

Definately make a field for each question, you will be able to choose different field types such as text, dates and checkboxes etc. So for the field "Did you like the book" you only have to click the tickbox rather than typing yes. Also memo fields can hold large volumes of text in case you have a "any thoughts" question and are worried that somebody will write a mini essay for you

By using forms you should be able to make entering the data into the database look the same as entering it into the survey form

 

[RuralGuy]

Maybe Duane Hookom can help. At Your Survey 2000 (354 KB)