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?
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