Exam 8: Sharing, Integrating, and Analyzing Data

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import and Link group on the External Data tab and allows the user to run an import process that was previously saved.

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

Case Based Critical Thinking Questions 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 contacted each local chapter of the non-profit organization and asked for local donor information. Some local chapters use Excel to record the information, some use Access, and some use other database or spreadsheet applications.  To streamline the import process, Brij has asked each local chapter to send him the information in a(n)____ document that is well suited for data exchange among many different programs.

A static web page changes any time the data exported to the web page are changed in the Access database.

Case Based Critical Thinking Questions 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 been asked to share a report with the non-profit's Board of Directors which lists all donors by state.  Brij created a query to appropriately sort the data and generated the report using Access.  The report will be shared using e-mail.  Which option is Brij most likely to choose to share this information?

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 and Cayla have successfully imported all of the data from the school system's assessments into the Access database.  Multiple queries have been created from the data, and the school system administrators would like to share the data with the school administrators and teachers using their secure Intranet.  What is the best method to use to share the information so that it is easy to read using a Web browser?

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

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

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

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

A chart created with the Access Chart Wizard is ____ in Access.

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

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.