Exam 4: Access: Sharing Integrating and Analyzing Data

All of the following are ODBC databases EXCEPT ____.

When you ____ an object to a form report or field you include a connection in the destination program to the original file maintained by the source program.

The row area of a PivotTable consists of a detail field and detail values.

All of the following are Access export options EXCEPT ____.

The PivotTable uses the Office PivotTable ____ which is part of Office 2007.

You can create a Web page by typing all the necessary HTML code into an HTML document and saving it with the appropriate file extension.

The Web browser uses a(n)____ to find and retrieve a Web page and then displays it on your computer screen.

Each digital document on the Web is called a Web ____.

If an XML import will occur on a set schedule you can create a reminder task in Microsoft Outlook.

The Presentation tab options in the Export XML dialog box let you export a separate ____ file containing the format specifications for a given table's data.

The ____ of a PivotTable provides details or totals from a database table or query.

Each ____________________ in the plot area of a PivotChart makes it easier to see the values represented by the data markers.

The Table Analyzer looks for concatenated data in a table.

You should always select the "Export data with formatting and layout" option because not selecting it results in an HTML document that is poorly formatted.

You embed the data when the source program will continue to maintain the data in the file and you need to use an updated version of the file at all times in the destination program.

Tags for ____ connect one Web page to another.

____________________ is the source program that the Chart Wizard uses to create a chart.

The item marked 2 in the accompanying figure is the ____ field.

If you use a tab control the control appears with tabs along the bottom with one tab for each page.

Each Web page is assigned an Internet address called a(n)____.