Creating an Update Query Create a query that updates students’ credits to account for the books they ’ve ordered and received. Click the Run button to test the query. When prompted to change the records, answer “Yes”. Save the query as Credit Update.