1-866-245-5224 sales@keystonelearning.com

Access 2003: Sorting a Table and a Form

Access 2003: Sorting a Table and a Form

If you look at any table or form, you can probably tell right off the bat how the data is sorted – by Primary Key.

But, since the Primary Key is a unique qualifier, it’s often easier to find data if you can sort by something more meaningful like Last Name or Company. This way, you can quickly find the data you’re looking for without spending lots of time sifting through record after record.

Sorting a Table

You can sort your table data using a couple of different methods.

Sorting a Table Using the Standard Toolbar
     
  1. Open the Table you want to sort
     
  2.  
  3. Click inside the field you want to sort by
     
  4.  
  5. Click the Sort Ascending or Sort Descending command on the Standard toolbar
     
Sorting a Table Using the Field Heading
     
  1. Open the Table you want to sort
     
  2.  
  3. Right-click the field heading of the column you want to sort by
     

 

Figure 21. Field Shortcut Menu

          3.      Choose Sort Ascending or Sort Descending from the Shortcut menu

 



Removing a Sort Order
     
  1. Display the Table you previously sorted
     
  2.  
  3. Choose Records: Remove Filter/Sort from the Menu bar
     

 

Sorting a Form

When working with a form, it’s often easiest to sort using the Shortcut menu.

Sorting a Form Using the Shortcut Menu
     
  1. Open the Form you want to sort
     
  2.  
  3. Right-click the field you want to sort by
     

 

Figure 22. Form Field Shortcut Menu

    3.     Choose Sort Ascending or Sort Descending

Removing a Sort Order
     
  1. Display the Form you previously sorted
     
  2.  
  3. Choose Records: Remove Filter/Sort from the Menu bar