Review the Data: Sort

Access can Sort the records as well.

 

3. Try it: Sort the Records

Select a Field: Year.

Go to Home ->Sort & Filter.

Click on Descending.

 

What Do You See? The Movies are sorted by Year from the newest (2012) to the oldest (1953).

 

One more comparison to the Microsoft Excel spreadsheet....

Home ->Sort & Filter-> Descending

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.3. Sort and filter records: Sort the Records