Query: Sort the Records
Look at
the QBE Grid at the bottom. There are several Rows of options that
you can program if you wish. Start with a simple function: Sort the
Records.
4.
Try it: Sort the Records
Go to a
Field: Year
Click on
the Sort Row under the Field.
Select a
Sort Order: Descending.
Try
This, Too: Run the Query
Go to
Query Tools ->Design-> Results.
Click on
Run.

Keep
going...