Using Access 2016

Create a new query using Design view. From the Clients table, add the ZIP field. Change the query type to Update and set the criteria to update zip codes of 07003 to 07003-9999. Run the query (two records will update). Save the query as Zip Code_Update and close the query. Use the Find command to view the updates in the Clients table and close the table.