Case Based Critical Thinking QuestionsCase 8-1The 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
Answer: B
You might also like to view...
Answer, and explain: For large lists, which of the following is true of inserting a new item into a linked list compared to insertion in an array? What of small lists?
a) more efficient. b) less efficient. c) about the same. d) depends on the size of the two lists.
Answer the following statement(s) true (T) or false (F)
Fill in the blank(s) with the appropriate word(s).
PCIe cards fit in PCI expansion slots
Indicate whether the statement is true or false
Enhancing the appearance of a table is made possible by which of the following features?
What will be an ideal response?