Good Morning All
I use to work in Access, SPSS, & SAS (years ago). However, I am a little lost and have a demographic project I HAVE to get going on TODAY! I've read a lot of posts and it seems to confuse me more than ever.
Attached is the Demographic Survey. There were approximately 600 respondents, from 5 of our area tranist stations. We just need to have a simple database form(s) set up with other tables.
Basically, I need help setting up the original form and THINK I need to have 3 separate tables attached for the different sections.
Sections are (in the order they appear on the survey):
Demographic Information (Age, gender, race, birth country, income, city they live in)
Tranisit passenger info: Route currently riding / boarding; How they would like to receive information about MCT; How they pay for bus fare; How often they ride the bus: Purpose of bus trip; Vehicle available in household.
Interviewer Info: Route #, Bus #, Starting Location (we have transit stations in 5 area cities), Interview location (options: Transit Station, inside moving bus, or inside a parked vehicle AT the transit station), Interview Time, Interview Date, and Day of Week.
I KNOW I'm asking for a lot, but I'm on a serious deadline and would appreciate setting up the INITIAL form accurately so I can create queries to analyze the information.
Please refer to the attached form showing the survey.
THANK YOU!!!! I just need a basic data base with tables so I can analyze data.
Julie
:banghead:
I use to work in Access, SPSS, & SAS (years ago). However, I am a little lost and have a demographic project I HAVE to get going on TODAY! I've read a lot of posts and it seems to confuse me more than ever.
Attached is the Demographic Survey. There were approximately 600 respondents, from 5 of our area tranist stations. We just need to have a simple database form(s) set up with other tables.
Basically, I need help setting up the original form and THINK I need to have 3 separate tables attached for the different sections.
Sections are (in the order they appear on the survey):
Demographic Information (Age, gender, race, birth country, income, city they live in)
Tranisit passenger info: Route currently riding / boarding; How they would like to receive information about MCT; How they pay for bus fare; How often they ride the bus: Purpose of bus trip; Vehicle available in household.
Interviewer Info: Route #, Bus #, Starting Location (we have transit stations in 5 area cities), Interview location (options: Transit Station, inside moving bus, or inside a parked vehicle AT the transit station), Interview Time, Interview Date, and Day of Week.
I KNOW I'm asking for a lot, but I'm on a serious deadline and would appreciate setting up the INITIAL form accurately so I can create queries to analyze the information.
Please refer to the attached form showing the survey.
THANK YOU!!!! I just need a basic data base with tables so I can analyze data.
Julie
:banghead: