Edit the Update Query You can use the Criteria to select different Years if you wish. We'll go back to the Select Query and test the new Criteria. This Criteria will select all of the Movies that were released before the Year 2000. Then we'll create an Update Query and review the results.   Before You Begin: Change the Query Type Go to Query Tools->Query Type->Select.   What Do You See? The Update Row is gone.   8. Try This: Edit the Criteria Select a Field: Year Edit the Criteria: <2000   Keep going.   Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.1. Construct queries: Update Queries Query Tools->Query Type->Select