SORTING AND QUERYING DATA

Sorting and querying data

      This example teaches you how to import data from a Microsoft Access database by using the Microsoft Query Wizard. With Microsoft Query, you can select the columns of data that you want and import only that data into Excel.

     1. On the Data tab, click From Other Sources, From Microsoft Query.

     The 'Choose Data Source" dialog box appears.

     2. Select MS Access Database* and check 'Use the Query Wizard to create/edit queries'.

     3. Click OK.

     4. Select the database and click OK.

     This Access database consists of multiple tables. You can select the table and columns you want to include in your query.

     5. Select Customers and click the > symbol.

     6. Click Next.

     To only import a specified set of records, filter the data.

     7. Click City from the 'Column to filter' list and only include rows where City equals New York

     8. Click Next.

     You can sort your data if you want (we don't do it here).

     9. Click Next.

     10. Click Finish to return the data to Microsoft Excel.

     11. Select how you want to view this data, where you want to put it, and click OK.

     Result:

     Note: when your Access data changes, you can click Refresh to update the data in Excel.

.

      Freeze pane

     Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Top Row option in the popup menu.

 

 

 

Data validation :