Exam 9: Sharing Integrating and Analyzing Data

The ___________________ dialog box opens when the Saved Imports button is clicked in the Import & Link group on the EXTERNAL DATA tab and allows the user to run an import process that was previously saved.

In the accompanying figure, arrow number 2 indicates which element of the chart?

To add a copy of a picture to a form when no changes will be made to the picture at any time after it is added to the form, it is best to ____________________ the picture.

Which of the following is the file extension associated with an Access template?

A new database file is created using a standard template .____________________

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

A specialized template which may contain tables, relationships, queries, forms, reports, and other database objects that can be imported into an existing database is a(n) ____________________.

A ____ may be inserted manually using the Page Break tool to make navigation of a large form easier by using the Page Up and Page Down keys on the keyboard.

While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____.

The form control that appears in the Access window with tabs at the top is the ____ Control.

In the accompanying figure, the data enclosed in the green rectangle are data imported from a CSV file that have been ____ by commas.

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

Table or query data may be exported directly to the mail merge feature in Microsoft Excel .____________________

All records in an Access table exported as XML begin and end with which XML tag?

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

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

In the accompanying figure, the ____ is indicated by arrow number 1.

A new database file is created using a standard template .____________________