Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

ECDL Exam ECDL-ADVANCED Topic 8 Question 41 Discussion

Actual exam question for ECDL's ECDL ADVANCED WORD PROCESSING exam
Question #: 41
Topic #: 8

You have a table named Expressions in Microsoft Office Access 2007 and you export this table directly to a SharePoint list. Which of the following actions will MS Access perform while you export the table?

Show Suggested Answer Hide Answer
Suggested Answer: D

When you export the table from MS Access 2007 to SharePoint list, it creates a copy of the table and stores the copy as a list. Access 2007 can export the table directly to SharePoint list. The contents of this list are static and the changes does not reflect to the source table after exporting the table. You cannot overwrite or add data to the existing list.

Answer option C is incorrect. An Access creates a RTF (Rich Text Format) document if you are exporting information from Access 2007 to Word. This RTF document can be opened by Word and various other applications.

Answer option B is incorrect. An Access converts the table to an HTML table if you are exporting the table from Access 2007 to an HTML file.

Answer option A is incorrect. An Access exports only the main datasheet if you export the table from Access 2007 to Excel and the table contains a subdatasheet. To export the subdatasheet, you should perform another export operation. In order to combine multiple Access objects into a single Excel workbook, you should export the individual objects to different workbooks, and then merge all the worksheets from within Excel.


Objective: Import, Export and Link data

Contribute your Thoughts:

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

Save Cancel