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.
-Zach has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database. He would like to import each Excel worksheet as a separate table into the database. What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?
A)save the Excel workbook as a PDF file
B)export the Excel data for each school as a CSV file
C)export the Excel data for each school to an XSL file
D)save the Excel worksheet as an HTML document

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.
-Zach has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database. He would like to import each Excel worksheet as a separate table into the database.  What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?
A)save the Excel workbook as a PDF file
B)export the Excel data for each school as a CSV file
C)export the Excel data for each school to an XSL file
D)save the Excel worksheet as an HTML document

Quizplus · Accepted Answer

The best option for Zach to use to create a file from the Excel data that can be imported into Access is to export the Excel data for each school as a CSV file. CSV files are commonly used for importing and exporting spreadsheet data between different software applications and are compatible with Access. Saving the Excel workbook as a PDF, exporting the Excel data for each school to an XSL file, or saving the Excel worksheet as an HTML document will not create a file that is easily imported into Access.