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

Access 2007: Sorting a Table and a Form

Access 2007: 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 Ribbon

1.       Open the Table you want to sort

2.       Click inside the field you want to sort by

3.       Click the Sort Ascending or Sort Descending command in the Sort & Filter group on the Home tab

Sorting a Table Using the Field Heading

1.       Open the Table you want to sort

2.       Click the field heading of the column you want to sort by

Sort.JPG

3.       Choose Sort A to Z or Sort Z to A

Removing a Sort Order

1.       Open the Table you want to sort

2.       Click the Clear All Sorts command in the Sort & Filter group on the Home tab

 

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.       Right-click the field heading of the column you want to sort by

FormSort.JPG

3.       Choose Sort A to Z or Sort Z to A

Removing a Sort Order

1.       Open the Table you want to sort

2.       Click the Clear All Sorts command in the Sort & Filter group on the Home tab