ECDL Exam ECDL-ADVANCED Topic 8 Question 41 Discussion

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.

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Import, Export and Link data