help with the solution put in Microsoft ACCESS FOLLOW DOCUMENTS 1-5

View table structure for Breed, Pet,Pet_3, Pet_Owner and save the results in a word document. Identify the Primary key for each table Create relationship between the tables as it fits Create a form for each table see the following image as an example: Brand Font BreedName MinWeight 15 MaxWeight 32.5 AverageLifeExpectancy 20 Add Record Print Record Close Form Quit App . Generate a report for each query in part II. PART -II Create the following Queries: 1- Create a query to display all columns of all rows of PET. 2- Create a query to display the PetBreed and PetType of all pets. 3- Create a query to display the PetBreed , PetType , and PetDOB of all pets having the PetType of Dog. 4- Create a query to display the PetBreed column of PET. 5- Create a query to display the PetBreed , PetType and PetDOB of all pets having the PetType of Dog and the PetBreed of Std. Poodle. 6- Create a query to display the PetName, PetBreed and PetType for all pets that are not of PetType of Dog , Bird or fish. 7- Create a query to display the PetID, PetName, PetBreed and PetType for all pets having a four - character name starting with k. (hint use Like ) 8- Create a query to display the OwnerLastName, OwnerFirstName and OwnerEmail of all owners who have an email address ending with somewhere.com. Assume that email account names can be any number of characters. Note: When you finish upload the completed pet database to moodle.BreedName - MinWeight - MaxWeight - AverageLife - Click to Add - BorderCollie 15 22.5 20 Cashmier 10 15 12 Collie Mix 17.5 125 18 INER Std. Poodle 22.5 BO 18 Unknown View Record: 14 1 5 of 5 Search Type here to search e ABREED PET OWNER PETIS TI PET OwnerID - "LastName - FirstName - Phone - Email - Click to Add - Downs Marshall 555-123-6788 MD@somewhere.com 2 James Richard 555-444-0098 PJ@somewhere.com 3 Frier Liz 555-444-5596 LF@somewhere.com 4 Trent Miles 555-999-8861 MT@somewhere.com 5 Rogers Jim 555-232-3456 6 Keenan Mary 555-232-4567 7 Melnik Nigel 655-232-5678 (New) Records is 1 of 7 Search e to searchBREED PET OWNER PET 3 PET PetID Name Type Breed Weight - OwnerID - Click to Add Kino Do std. Poodle 25.5 2 Teddy Cat Cashmier 10.5 3 Filo Dog std. Poodle 28.5 4 AU Dog Collie Mix 2010 5 Cedro Cat Unknown 9.5 6 Woolley Cat Unknown 19.5 #7 Buster NNW Dog BorderCollie (New) Record 14 1 of 7 be here to search WSort & Filter Records BREED HE PET OWNER NEE PET S HE PET PetID Name Types Breed DOB OwnerID - Click to Add 1 King Do Std. Poodle 2/27/2009 2 Teddy Cat Cashmier 2/1/2010 3 Filo Dog std. Poodle 7/17/2008 4 AJ Dog Collie Mix 5/5/2009 5 Cedro Cat Unknown 6/6/2007 6 Woolley Cat Unknown 7 Buster. Dog BorderCollie 12/11/2006 ( New) | Search