Why Form 5495 Survey 2017-2023

Instructions and Help about Why Form 5495 Survey

I'm gonna demonstrate how to build a database and access from a survey that we conducted a couple years ago on the Westminster College campus this is our survey and we print off a bunch of copies and we had administrators of the survey go around and ask students for his questions like what year in college were they make your school whether they attended past maid term trips whether their interests whether they're enrolled in May term that's coming up their interest in going on a midterm trip areas of interest countries of interest the highest cost we want to pay experiences that there that is desired by the student on these trips and then any other component so I'm gonna set this aside for a second and open up access and this is going to be basically transferred to access into a survey form where after these are all filled out with pins in personal interviews the person conducting the survey can upload it to the database and this part of the survey this part of the survey and this part of the survey is actually contained already in Excel so we have areas which looks just like the stuff on the form we have countries which are blanks on the form currently so they're blank over here and then we have experiences desired which are exactly like the experiences listed on the survey form so this part of the survey this part of the survey and this part the survey are going to be imported into access and I'll go ahead and do that right now so we're gonna go to we're gonna click on external data tab click on the Excel button here that may term data is those tables are stored on the desktop so...