Exam 4: Access: Sharing, Integrating, and Analyzing Data

Access uses ____ as the source program to create a graph when the Chart Wizard is used.

The encoding method for exporting Access data to an XML file which uses 16 bits to represent each character is the ____________________ encoding method.

Data from an Access database exported to an XML file are contained in ____.

Case Based Critical Thinking Questions Case 8-2 Brij has just been promoted to Marketing Manager of a non-profit organization responsible for soliciting over three million dollars in donations annually. His company solicits donor information from local chapters of the non-profit organization. Brij decides to create an Access database that will allow him to keep all donor information in one database and create reports as well as marketing documents using the database. Based on your knowledge of importing and sharing Access data, answer the questions below. Brij has already created the table structure he wants to use in his database. Therefore, when he imports the data from the local non-profit organizations, he will ____ the data to his existing table.

To add a copy of a picture to a form when no changes will be made to the picture at any time after it is added to the form, it is best to ____________________ the picture.

Discuss why XML files are often used to exchange data between companies and between programs within a company.

Which type of file contains the format specifications for Access table data when exporting table data as an XML file?

External data imported from a CSV file into an Access database may only be appended to an existing table.

Tools for exporting data from Access are available on the DATABASE TOOLS tab.

Using the minimum size option when saving a ____________________ file does not include functionality for screen readers.

In the accompanying figure, the ____ is indicated by arrow number 1.

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.

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

A new database file is created using a standard template .

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

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

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

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.

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

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