Exam 8: Performing What-If Analyses

_____ connects an Access database to data in an external file,such as an Excel spreadsheet or Outlook folder,but does not copy the data into the database.

Export query data as a(n)_____ file if you want to open the file in a browser.

A(n)_____ chart best illustrates the contribution of three products to total company sales in a year.

The _____ property indicates which field serves the link between the main form and subform.

Export form data to a(n)_____ file to present the data as a webpage for a person,not a program,to read.

An Access chart displays data in rows and columns,similar to a spreadsheet.

When exporting to XML,Access creates an _____ helper file that contains a description of the data's characteristics.

A common example of delimited text file is a PDF file.

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

To share form data among two or more programs,export the form as a(n)_____ file.

When using the Chart Wizard,you can drag a Number field to the Data area of a chart to have the wizard automatically _____ the values in the field.

When you export table data to a PDF file,you need software such as _____ to view the data.

An advantage of emailing query results as a PDF file is that _____.

When you copy data from an external file into an Access database,you are importing the data.

An HTML document is a text file that uses _____ to mark up content stored in the file.

If you export form data as a(n)_____ file,you can view the data but not change it.

Which two properties control how a form and subform are linked?

Before using the Chart Wizard,you should plan which fields you want the chart to display.

A(n)_____ file is a text file containing Extensible Markup Language tags that identify field names and data.

A(n)_____ chart typically shows cumulative totals,such as combined sales totals for store locations.