Which of the following actions will MS Access perform while exporting the table from Access to Excel?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datasheet named
Datasheet1. You want to work with contents of this table in Excel 2010. In order to perform this task,
you need to export the table. Which of the following actions will MS Access perform while exporting
the table from Access to Excel?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datasheet named
Datasheet1. You want to work with contents of this table in Excel 2010. In order to perform this task,
you need to export the table. Which of the following actions will MS Access perform while exporting
the table from Access to Excel?

A.
It exports only the main datasheet.

B.
It creates an RTF document.

C.
It converts the table into an HTML table.

D.
It creates a copy of the table and stores the copy as a SharePoint list.

Explanation:
When you export a table from Microsoft Office Access 2010 to Excel and the table contains a subdatasheet, it exports only the main datasheet. To export the sub-datasheet, you should perform
another export operation. In order to combine multiple Access objects into a single Excel workbook,
you should export individual objects to different workbooks, and then merge all worksheets from
within Excel.
Answer B is incorrect. Microsoft Office Access 2010 creates an RTF (Rich Text Format) document if
you export information from Access to Word. This RTF document can be opened by Word and
various other applications.
Answer C is incorrect. Microsoft Office Access 2010 converts a table into an HTML table if you
export the table from Access to an HTML file.
Answer D is incorrect. Microsoft Office Access 2010 creates a copy of the table and stores the copy
as a list if you export the table from Access to the SharePoint list.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


jean

jean

When export a table from Access 2010 to Excel and the table contains a sub-datasheet, it exports ONLY the MAIN datasheet.