Exam 8: Sharing, Integrating, and Analyzing Data

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

A(n)____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

When a table is exported using the Export to HTML tool, the web page that is created is a static web page.

The data value of each data item in a chart is represented by ____________________.

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. -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.

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?

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. -Each Excel worksheet that was exported contained column names.  Those names will appear in the first row of the Import Text Wizard and may be used as the ____ in the Access table.

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

Document structure tags may be added to a(n)____ exported from a database to add accessibility features.

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database..

Data in an Access table linked to an Excel source file may be edited using which process?

XML tags allow screen readers to easily navigate and voice information in a database exported as a PDF file.____________________

Access uses the ____________________ program to edit charts created with the Chart Wizard in Access.

While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____.

Access objects, including tables, queries, forms, and reports, may be exported from Access to an XML file.