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...

Query Tools ->Design-> Results->Run

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Sort the Records