To work By Data Sheets in MS Access, see the following image:

 

Data_sheets

 

Following image shows how to use shortcut menu (activated by right click of mouse) on the Column headers:

 

Data_sheets2

 

In the Data sheet view, user can select one or more columns and by Drag & Drop, change the location of them in the view.


For example, user selects both 'Task Title' and 'Status' columns then sort them. the following image is the result:

 

Data_sheets_sort1

 

First 'Task Title' sorts and then 'Status' based on 'Task Title'

Then user can move column 'Status' to left side of the 'Task Title' and then select both to sort them Descending (Z to A) based on 'Status' like below:

 

Data_sheets_sort2

 

 

Created with the Personal Edition of HelpNDoc: Create iPhone web-based documentation