2012

To hide a column in a database table
1 In the Data View window, select the column header of the column that
you want to hide.
2 Right-click the column header. Click Hide.
To display all hidden columns in a database table
■ Right-click any column header in the Data View window. Click Unhide
All.
To specify a sort order for the Data View window display
1 Right-click any column header in the Data View window. Click Sort.
2 Select a column to sort in the Sort By list. Select Ascending or Descending
to specify a sort order.
Ascending order sorts the column starting with the smallest value and
ending with the largest value. Descending order sorts the column starting
with the largest value and ending with the smallest value.
3 If desired, select an additional column to sort in the Then By list. Select
the Ascending or Descending option to specify a sort order.
The sort operation sorts all database table records according to the value
specified in the Sort By list, and then continues to sort based on the value
specified in the Then By list.
4 Repeat step 2 for any additional fields that you want to add to the sort.
You can sort by a combination of up to five table columns at a time.
To freeze a column or columns
1 In the Data View window, select one or more columns to freeze.
2 Right-click one of the selected column headers. Click Freeze.
NOTE The Freeze option can be applied only to contiguous columns. If not all of
the columns you want to freeze are contiguous, move them as described in To
move a column in a database table.
To unfreeze all frozen columns
■ Right-click any column header in the Data View window. Click Unfreeze
All.
View Data in a Database Table | 2011