Exam 8: Sharing, Integrating, and Analyzing Data

An Access database may be saved as a template .____________________

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

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

The default encoding method for exporting Access data to an XML file is UTF-8, which uses 8 bits to represent each character.____________________

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

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

Only the default name may be used for saved import steps in the Get External Data dialog box.

Use the Link to the data source by creating a linked table option from the Get External Data - Excel Spreadsheet dialog box to create a table in a database that adds the source data from an Excel spreadsheet and updates the data in the table each time the source file is updated.____________________

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

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?

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

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

Begin the process of importing an XML file on the External Data tab in the ____________________ group.

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

The process of identifying and eliminating anomalies from a collection of tables is called ____.

To use an application part in an existing database, choose ____ from the Create tab on the ribbon to view the application parts gallery..