Asked by Riana Doretti on May 16, 2024
Verified
To export query data to Excel, you _____.
A) save the query as an XLSX file
B) click the Create tab, and then click the Excel Query button in the Queries group
C) click the External Data tab, and then click the Excel button in the Export group
D) select Excel as the destination when you run the query
External Data Tab
In software applications, a section that allows users to import or link to data from external sources.
Excel Query Button
A tool in Microsoft Excel that allows users to import data from various sources into their spreadsheet for analysis.
Export Group
A function or feature in software applications that allows users to batch process and export multiple data files or objects together.
- Learn how to export data from Access to other formats like Excel, HTML documents, and text files.
Verified Answer
AF
Aaryan FarooquiMay 19, 2024
Final Answer :
C
Explanation :
To export query data to Excel, click the External Data tab in the Ribbon, then click the Excel button in the Export group. This will launch the Export - Excel Spreadsheet wizard, where you can choose to export the entire database or a selection of tables, specify any formatting options, and save the file with a custom name and location.
Learning Objectives
- Learn how to export data from Access to other formats like Excel, HTML documents, and text files.