Why Form 5495 Survey 2017-2023

I'm gonna demonstrate how to build a database and access it from a survey that we conducted a couple of years ago on the Westminster College campus. This is our survey, and we printed off a bunch of copies. We had survey administrators go around and ask students various questions such as their college year, school attendance, past May term trips, interests, enrollment in upcoming May term trips, areas and countries of interest, highest cost they're willing to pay, desired experiences on these trips, and any other comments. Now, I'm going to set this survey aside for a second and open up Access. We will transfer the survey data into Access to create a survey form. After the forms are filled out with pen or through personal interviews, the survey conductor can upload the data to the database. This survey is divided into multiple parts, which are already organized in an Excel file. We have sections for areas, countries, and desired experiences. However, the countries section is currently blank on the survey form. To import the survey data into Access, we will go to the external data tab and click on the Excel button. The data tables are stored on the desktop, so we click on the appropriate file. We ensure that the three worksheets for areas, countries, and experiences are selected. Next, we verify that the first row contains column headings and proceed by selecting "yes" for no duplicates. We choose to define our own primary key instead of using the Access default. Once we have our primary key, we name the table "areas" to match the worksheet name in Excel. We repeat the same process for the countries and experiences worksheets. Now, if we double-click on any of the imported tables, they should look identical to the data...