Use the attached database. 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. Use SQL queries to do the following:

• Display the last name and phone number of all dog owners. Use a subquery.
• 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 the three queries.

Export the PET table to an Excel spreadsheet. Use the Excel to make 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.  Save the 4 screen shots Word document as Screen shots. Save the pivot table as Pivot.

SophiaPretty

(5)

Status NEW Posted 14 Nov 2017 09:11 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer