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…

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…

Managing the Access Environment

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.

How the community answered

(56 responses)

A
84% (47)
B
2% (1)
C
5% (3)
D
9% (5)

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.

Topics

#export to Excel#sub-datasheet#main datasheet#data export

Community Discussion

Dragomir B.Jun 9, 2026

A is correct. When you export a table from Access 2010 to Excel, Access only exports the main datasheet, it ignores any sub-datasheets entirely, so Datasheet1 just gets left behind in the process.

Fatima Z.Jun 10, 2026

Right, and just to lock that in your brain, picture the sub-datasheet as the kid who overslept and missed the Export Bus entirely, because Excel never even honks for it, no matter how many sub-levels deep your Access table goes.

Yusuf A.May 12, 2026

The answer is A, it only exports the main datasheet. When Access sends a table over to Excel, it does not bring the sub-datasheet along for the ride, so Datasheet1 would just get left behind. My senior actually warned me about this before I sat, he said Microsoft specifically designed it that way because Excel has no native concept of a nested sub-datasheet the way Access does, so there is nowhere for that second layer to even land. I got a question worded almost exactly like this on my exam and almost second-guessed myself into picking D because I kept thinking SharePoint integration was somehow involved, but then I remembered what he told me and went with A and it was right.

Fatima Z.May 23, 2026

Sub-datasheets do NOT travel to Excel, so A nails it, Access drops them flat.

Anjali D.May 31, 2026

Good discussion everyone. The group is landing on A and that is the right call. When you export a table from Access 2010 to Excel, Access only takes the main datasheet along for the ride, it does not pull the sub-datasheet with it. So Datasheet1 in this scenario would just get left behind, which is a common gotcha that trips people up on this exam. The other options do not fit at all since exporting to Excel produces an .xlsx file, not an RTF document, an HTML table, or a SharePoint list. Anyone who has actually tried this in Access can confirm you have to handle sub-datasheets separately if you need that data too.

Hiroshi T.May 19, 2026

The Microsoft Office 2010 Access documentation on the export workflow describes the process of moving tabular data to Excel as a conversion step, and the intermediate format that Access uses when bridging to spreadsheet applications is HTML, so C is the right call here. The table structure has to be rendered into a portable format that Excel can read, and HTML tables fit that description perfectly given how Office 2010 handles cross-application data transfer.

-1

Dragomir B.May 20, 2026

Respectfully, Hiroshi, Access 2010 exports directly to a native Excel workbook file, no HTML middle step involved, which is why A is correct. The HTML export is a separate workflow entirely and has nothing to do with how Access hands data off to Excel.

Full 77-885 Practice