Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Use the Week 3 Assignment Pet_Database File for this section of the assignment. In the PET table, delete the PetDOB field and add a numeric PetCost field. Populate this field with appropriate values.

Use the Week 3 Assignment Pet_Database File for this section of the assignment. In the PET table, delete the PetDOB field and add a numeric PetCost field. Populate this field with appropriate values. Save the changes to the PET table. Create SQL queries to do the following:

  • Display the last name and phone number of all dog owners. Use a subquery to do this.
  • Display the first and last name of owners and the type of animal of all unknown breeds.
  • Display the pet name and owner last name of all dogs.

Save all 3 queries.

Export the PET table to an Excel spreadsheet. Create a Pivot table. Have the cost display as currency. Take screen shots* of two different views without a report filter and paste the screen shots into a Word document. Then add a report filter and choose one value for it, take a screen shot, then choose a different value for the same filter and take another screen shot. Paste those into the Word document containing the first two screen shots. You should now have 4 screen shots in this Word document. Save the Word document as Screen shots. Save the pivot table as Pivot.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question