Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.1 Create a Query: Sort a Query

Query: Sort You can Sort and Filter a Query, just as you would a Table. Here are the steps.   6. Try it: Sort the Records The MovieSQ results are still open in datasheet view. Select a Field: Year Go to Home ->Sort & Filter. Click on Descending.   What Do You See? The Records should be sorted by Year: descending means the new movies will be on top.   The Wizard is a good way to get started. Let's look at the Query Design. Home ->Sort & Filter->Descending