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 newest movies will be on top.   The Wizard is a good way to get started. Now, let's look at the Query Design. Home ->Sort & Filter->Descending Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Manipulate fields: Use Sort and Show Options