Case Based Critical Thinking Questions
The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information. Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year. Answer the following questions using your knowledge of Access tools for sharing and integrating data.
-Cayla wants to create a new table for each of the imported files. Which option should she choose from the dialog box that appears during the import process?
A)Append a copy of the records to the table
B)Link to the data source by creating a linked table
C)Import the source data to an existing table
D)Import the source data into a new table in the current database

Question

Case Based Critical Thinking Questions
The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information.  Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year.  Answer the following questions using your knowledge of Access tools for sharing and integrating data.
-Cayla wants to create a new table for each of the imported files.  Which option should she choose from the dialog box that appears during the import process?
A)Append a copy of the records to the table
B)Link to the data source by creating a linked table
C)Import the source data to an existing table
D)Import the source data into a new table in the current database

Quizplus · Accepted Answer

Cayla should choose "Import the source data into a new table in the current database" to create a new table for each imported file. This option will allow her to create a new table with the data from each file without overwriting any existing tables or data.