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

Rearrange the Fields Queries read from Left to Right. You can move and rearrange the Fields. It is similar to moving a Column in Microsoft Excel.   7. Try it: Rearrange the Fields Select the Year Field by clicking on the Field Header. The whole column should be highlighted (black).   Drag and Drop the Year Field between MovieID and Movie.   Try This, Too: Add Another Sort Order Go to a Field: Movie Click on the Sort Row under the Field. Select a Sort Order: Ascending.   Keep going... Query Tools ->Design