Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.3 Manage Record: Update Records With an Action Query

Update the Oldies The same Query that selected the Movies can be changed into an Action Query and Update the Archive Field to "Yes." Here are the steps.   Before You Begin: Change the View Go to Home->Views-View->Design View.   2. Try it: Create an Update Query Go to Query Tools ->Design->Query Type. Select a Query Type: Update.   What Do You See? There will be a new Row in the QBE grid: Update to.   Try This, Too: Enter the Update Value Go to a Field: Archived. Update to: Yes.   Better Do This, Now: Save the Query Go to File->Save. Enter a name: ArchiveMovieUQ, where UQ means Update Query.   Keep going... Query Tools ->Design->Query Type-> Update