Exam 9: Sharing Integrating and Analyzing Data

Case Based Critical Thinking Questions Case 8-1 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. After Cayla imports all of the data into the Access database, Zach will use the ____ tool to be sure there are no redundant data in the table and review the results carefully.

In the accompanying figure, the data enclosed in the green rectangle are data imported from a CSV file that have been ____ by commas.

Portions of an Excel workbook might be saved as an HTML file with values separated by commas so that the values in Excel may be imported into an Access table.____________________

In the accompanying figure, which numbered arrow indicates the chart legend?

To generate the most readable format for a table exported to HTML, always select the ____ option from the available export options.

Which of the following applications may be used to view an XML file containing the data and the code that describes the data?

In the accompanying figure, which tab control is active?

Access does not have the capability to create charts and drawings.

To generate the most readable format for a table exported to HTML, always select the ____ option from the available export options.

Case Based Critical Thinking Questions Case 8-1 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?

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

Developers may customize the ____________________ programming language to describe the data contained and the data structure.

In the accompanying figure, arrow number 2 indicates which element of the chart?

All major operating systems for desktop computers, as well as handheld devices, include software that will open and display the ____ file format.

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

A specialized template which may contain tables, relationships, queries, forms, reports, and other database objects that can be imported into an existing database is a(n) ____________________.

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

It is important to open the ____ file before opening a linked Access table.

The ____ tool is used from the Controls group on the DESIGN tab to create a chart based on field data from an Access table or query.

Case Based Critical Thinking Questions Case 8-1 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. Once Zach has created the appropriate files from the Excel workbooks, Cayla will import the data into the Access database.  Which tab will Cayla use from the Access Ribbon to begin the import process?