nerdexam
Microsoft

77-885 · Question #107

77-885 Question #107: Real Exam Question with Answer & Explanation

The correct answer is A. It exports only the main datasheet.. When you export a table from Microsoft Office Access 2010 to Excel and the table contains a sub-datasheet, 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

Question

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?

Options

  • AIt exports only the main datasheet.
  • BIt creates an RTF document.
  • CIt converts the table into an HTML table.
  • DIt 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 sub-datasheet, 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.

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice