Exam 9: Sharing Integrating and Analyzing Data

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

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

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

Predefined templates for Access databases that include tables, relationships, queries, forms, reports, and other database objects are displayed in ____________________ view.

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?

The Definition Only option must be chosen when importing both the structure and records of an external Access table using the Import Objects dialog box.____________________

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

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

To create a reminder for an import task that is repeated on a regular basis, a(n) ____ may be created.

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 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(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

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

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

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

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

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

The Access tool that analyzes a single table in a database and splits the table into two or more tables, if necessary, when it finds redundant data is the ____________________.

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

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

In the accompanying image, the selected field has been assigned which Data Type?