Exam 4: Access: Sharing Integrating and Analyzing Data

All the PivotTable areas can have multiple fields with associated field items.

The World Wide Web is commonly called the ____.

Navigation buttons do not appear in Form view.

The accompanying figure shows a(n)____________________.

A(n)____ field summarizes field values from a source field.

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

To open the Get External Data - Excel Spreadsheet dialog box click the External Data tab on the Ribbon and then in the Import group on the External Data tab click the Excel button.

Any changes you make to an embedded object are reflected only in the form report or field in which it is embedded.

The column area of a PivotTable consists of a column field and column field ____.

You can add ____ to your forms and reports.

If you do not see Subform in New Window as one of the options on the shortcut menu that results when you right-click the top edge of the subform control you did not click the top edge of the subform control correctly.

You can import from all of the following EXCEPT ____.

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

You import or link an object when you want a copy of the object in your form or report and you intend to edit the object using the source program in the future.

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

You link an object when you do not want your edits to the object in the destination program to affect any other copies of the object used by other programs.

When embedding data you can maintain the data using the destination program and the source program will always use the updated version of the file.

Most Web pages are created using a programming language called ____.

Access has built-in tools that convert objects to HTML documents for viewing on the Web.