What are the different types of queries available in MS Excel? Explain briefly using example.
Answers
Answer:
1. On the Data tab, in the Get & Transform Data group, click Get Data.
2. Click From Other Sources, From Microsoft Query.
3. Select MS Access Database* and check 'Use the Query Wizard to create/edit queries'.
4. click ok
5. Select the database and click OK.
6. Select Customers and click the > symbol.
7. Click Next.
To only import a specified set of records, filter the data.
8. Click City from the 'Column to filter' list and only include rows where City equals New York.
9. Click Next.
You can sort your data if you want (we don't do it here).
10. Click Next.
11. Click Finish to return the data to Microsoft Excel.
12. Select how you want to view this data, where you want to put it, and click OK.
13. When your Access data changes, you can easily refresh the data in Excel. First, select a cell inside the table. Next, on the Design tab, in the External Table Data group, click Refresh.
FINSHED
please follow me