ECDL Exam ECDL-ADVANCED Topic 3 Question 23 Discussion

Actual exam question for ECDL's ECDL-ADVANCED exam

Question #: 23
Topic #: 3

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?

AIt exports only the main datasheet.

BIt converts the table into an HTML table.

CIt creates an RTF document.

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 option C 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 option B 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 option 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.

Show Suggested Answer

Suggested Answer: A

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data

by Dominque at May 05, 2022, 09:05 PM

Limited Time Offer

25%

Off

Get Premium ECDL-ADVANCED Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!