Thursday, May 20, 2021

Materi Microsoft Access : How to set up and apply an advanced sort



a. How to sort records from the Home tab

  1. In the Navigation pane, double-click the table to open it in Datasheet view.
  2. Click the field you want to sort by.
  3. On the Home tab, in the Sort & Filter group, click Ascending or Descending.


b. How to sort records by using a shortcut menu
  1. In the Navigation pane, double-click the table to open it in Datasheet view.
  2. Right-click the field you want to sort by, and then click the command for the sort order you want to use. (The command names depend on the field’s data type.)

c. How to set up and apply an advanced sort
  1. In the Navigation pane, double-click the table to open it in Datasheet view.
  2. On the Hometab, in the Sort & Filtergroup, click Advanced, and then click Advanced Filter/Sort.
  3. In the Advanced Filter/Sort window, drag the field or fields you want to sort by to the Field row in the grid.
  4. In the Sort row, select the sort order you want to use.
  5. In the Sort & Filter group, click Toggle Filter to sort the records.
  6. Click Remove Sort to return the table to its default sort order.

No comments:

Post a Comment