Exam 4: Access: Sharing Integrating and Analyzing Data

A(n)____ file provides formatting instructions so that a browser or another program can display the data in the XML file in a readable way.

You ____ an object when you want your edits to the object in the destination program to affect the object used by other programs.

HTML documents are saved with the .htm or .html file extension.

The ____________________ analyzes a single table and if necessary splits it into two or more tables that are in third normal form.

The items marked 4 in the accompanying figure are the ____ values.

Any changes made to an object using the source program are not reflected in linked objects nor do they retain a relation to the source program.

A(n)____________________ is an interactive chart that provides capabilities similar to a PivotTable.

As shown in the graphic in the accompanying figure the data field identifies which values the data markers represent and identifies each value displayed as a(n)____________________ axis label.

You link a file as a new table when you intend to use Access to maintain the data and no longer need an updated version of the data with the source program.

You can create a multi-page form by using the ____________________ tool to insert a page break control in the form.

____ is an XML encoding choice that uses 16 bits to represent each character.

The ____ area of a PivotTable lets you restrict which data appears in the PivotTable.

For objects in forms or reports you ____ an object when you want a copy of the object in your form or report and you do not intend to make any changes to the object.

When importing the data you can maintain the data using the destination program.

The ____ is a worldwide network consisting of millions of interconnected computers.

Individuals and companies store their Web pages on special computers called Web ____.

The row area of a PivotTable consists of a row ____ and row field items.

The columnar bars for a column chart are called data ____.

In a PivotChart the ____ field identifies the data markers' subdivisions.

A ____ chart shows the relationship or proportions of parts to the whole.