graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query: Sort Data Within Queries

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.

 

graphic3

 

Keep going...

Query Tools ->Design-> Results->Run

graphic2