Just Query Syntax

DATA MODIFICATIONS

1. Add 6 more records to your table using INSERT. Include 3 examples of both INSERT methods (three with and three without field lists).

2. After entering data, modify the phone number for your 4^th record, by a specific license number. Change the phone to read (509) 555-9897. Provide the modify command.

3. Delete your third record by the owner's last name.

4. There has been a Postal realignment. Change all zip codes that read 99207 to now read 99208.

5. Mark Freeman has given his St. Bernard Rosco to his son-in-law Mason Reeves. Make the changes.