Microsoft Access a query and report that shows the total number of pets at the animal shelter and how many pets by type example how many cats, dogs etc  di

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Microsoft Access a query and report that shows the total number of pets at the animal shelter and how many pets by type example how many cats, dogs etc  discussed in class.
a query and report that shows the youngest and oldest pet show the number of oldest and youngest.
a query and report that shows total count of how many M and F pets are in the animal shelter. OwnerID OwnerLastName OwnerFirstName Address City State Zip Phone

0100 Smith Albert 11 Lakewood Drive Abilene TX 79601 3256149333

0101 Weston Mark 2601 Nonesuch Road Abilene TX 79606 3255551112

0102 Rivera Angela 2548 Laney Road Denton TX 76208 9403218020

0103 Moyer Silvia 6867 Anglebluff Circle Dallas TX 75248 9723806188

0104 Wills Mason 2421 Klondike Drive Dallas TX 75228 2142245555

ID PetName Type Breed Age Gender Color Details FKOwnerID

1 Abby Cat Domestic Short Hair cross 10 mths F Black Friendly, affectionate and social, I’m easy to love and a joy to be around. I have a curious nature which keeps me excited about the world around me all day long! I approach life with lots of enthusiasm. I am very inventive. I can turn any ordinary day into an adventure.   

 

Type of home I’m looking for: I want a home where my people will love me and let me sleep with them.
0100

2 Alec Dog Terrier cross Chihuahua 3 yrs M Tan I like to take my time approaching new situations. While I am a bit shy with new faces and places, I warm up as I become more familiar with my environment. While I don’t always like to be petted and held, I have a big heart and can’t wait to share all of my love with a special family of my own. I’m a lovable companion seeking a special home where I’ll be a cherished member of the family. With bright eyes and a precious face, I have a beautiful personality to match.   

 

Type of home I’m looking for: I would do best in a quiet home with no children or cats, please.

3 Allie Rabbit American cross 1 yr F Brown With my adorable long ears and fun-loving personality, I can’t wait to find a special family and home. Easy-going and quite lovable, I am thrilled to spend quality time with my people friends. I also love to munch on green veggies and delicious fruit! I also enjoy getting my exercise in “bunny-proof” areas of the home and I sometimes leap, skip and jump into the air!   

 

Type of home I’m looking for: A home where I will be an indoor bunny and a cherished member of the family.
0103

4 Barnaby Rabbit American cross 2 yrs M White With my adorable long ears and fun-loving personality, I can’t wait to find a special family and home. I like to take my time approaching new situations. While I am a bit shy with new faces and places, I warm up as I become more familiar with my environment. I also love to munch on green veggies! I also enjoy getting my exercise in “bunny-proof” areas of the home and I sometimes leap, skip and jump into the air!   

 

Type of home I’m looking for: A home where I will be an indoor bunny and a cherished member of the family.

5 Lilith Dog Chihuahua cross Dachshund 2 yrs F Black/White I can be a bit shy at first, but I warm up as I become more familiar with my environment and get to know you better. Whether we snuggle on the couch or enjoy a day at the park, I’m at home as long as I’m with you. My big, brown eyes will melt your heart. I love to put my eyes and ears to work, soaking up the sights and sounds of the world around me.   

 

Type of home I’m looking for: I would do best in a quiet environment with no children please.

6 Martin Cat Domestic Short Hair cross 1 yr M Brown Tabby/White I love to put my eyes and ears to work, soaking up the sights and sounds of the world around me. I’m known to make a lasting impression on everyone I meet. I like to take my time approaching new situations. While I am a bit shy with new faces and places, I warm up as I become more familiar with my environment.

7 Sasha Dog American Pit Bull Terrier 8 yrs F Tan/White Whether we snuggle on the couch or enjoy a day at the park, I’m at home as long as I’m with you. I’m a mellow and easy-going companion, content just to feel loved. I am an old soul looking for someone to spend my golden years with. I love to go for walks or stay home with my human friends!   

 

Type of home I’m looking for: I will do best in a calm home with kids who are at least 12 years old.

8 Tate Cat Domestic Short Hair cross 3 yrs M Black/White I’m a lovable companion seeking a special home where I’ll be a cherished member of the family. With bright eyes and a precious face, I have a beautiful personality to match. I like to take my time approaching new situations. While I am a bit shy with new faces and places, I warm up as I become more familiar with my environment.   

 

Type of home I’m looking for: I would do best in a quiet household with older children please.

9 Elsa Dog American Pit Bull Terrier cross 2 yrs F White/Brown With lots of fun-loving energy and charisma, I absolutely love to play! I am very inventive. I can turn any ordinary day into an adventure. I love to put my eyes and ears to work, soaking up the sights and sounds of the world around me. I have a curious nature which keeps me excited about the world around me all day long! I approach life with lots of enthusiasm.   

 

Type of home I’m looking for: I would do best in a home with children over the age of 8.

10 Hubert Dog Rat Terrier cross 3 yrs M White/Brown With lots of fun-loving energy and charisma, I absolutely love to play! Whether we snuggle on the couch or enjoy a day at the park, I’m at home as long as I’m with you.

11 Bessie Dog American Pit Bull Terrier 5 yrs F Black/White I like to take my time approaching new situations. While I am a bit shy with new faces and places, I warm up as I become more familiar with my environment. With lots of energy and charisma, I absolutely love to play and get my exercise. I would be thrilled to accompany my new pet-parents on their athletic pursuits and outdoor adventures.   

 

Type of home I’m looking for: I would prefer a quiet home with older children, please.

12 Connie Cat Domestic Short Hair cross 3 yrs F Tortoise Shell I have been here for a few months. This means the staff here has had plenty of time to get to know me. Everyone tells me I am purr-fect because I love to curl up on any bed and get lots of love. The 3 words that best describe me are sweet, sassy and spunky. A few other things you should know about me are that I would love to go to a home that appreciates my spectacular personality and spunk, where I can play all day and sleep snuggled next to my favorite person all night. Although I don’t really like to be held, I am one of the sweetest and best looking cats here. So walk no further and take me home!   

 

Type of home I’m looking for: I would prefer a home with an experienced cat owner and no young children.
0100

13 Topaz Rabbit American cross 1 yr F Brown Tabby I am a 1-year old American mix who is looking for a home where the treats are plentiful! My petite stature and beautiful black coat make me a pleasure to watch, especially as I dance around my pen showing off my binky skills!  Although I am cautious with new situations, a patient home will reap the rewards of my love. Some of my favorite activities include exploring and hopping around my x-pen, nibbling on yummy treats and playing with my favorite toys. I absolutely adore Timothy Hay and carrots! I promise that once I get comfortable, I’d love nothing more than the warmth of a lap and some petting time. Since I find too much activity a bit stressful, I am currently available for adoption, but living with a foster family.

14 Lady Dog Terrier cross 3 yrs F Black Brindle/White I can be a bit shy at first, but I warm up as I become more familiar with my environment and get to know you better. I appreciate close, trusting relationships. I enjoy relaxing, sleeping and snuggling by the side of a companion or a warm window. What thrills me most in life is sharing my love with those around me. I can’t wait to find a special family to cherish!
0104

15 Ashley Dog Australian Shepherd cross 3 yrs F White/Brown With lots of fun-loving energy and charisma, I absolutely love to play! Whether we snuggle on the couch or enjoy a day at the park, I’m at home as long as I’m with you. I love to put my eyes and ears to work, soaking up the sights and sounds of the world around me. I would be thrilled to accompany my new pet-parents on their athletic pursuits and outdoor adventures. I’m a lovable companion seeking a special home where I’ll be a cherished member of the family. With bright eyes and a precious face, I have a beautiful personality to match.

16 Bandit Cat Domestic Short Hair cross 5 yrs M Black/White I’m a lovable companion seeking a special home where I’ll be a cherished member of the family. With bright eyes and a precious face, I have a beautiful personality to match. While I don’t always like to be petted and held, I have a big heart and can’t wait to share all of my love with a special family of my own. While I enjoy spending quality time with my people friends, I am also content to spend time on my own. I have an independent spirit.

17 Vince Rabbit American cross 1 yr M White I’m a charming and delightful small animal companion looking for a special home and family to cherish! I enjoy entertaining my people friends, playing with my toys, and munching on my treats. I love to put my eyes and ears to work, soaking up the sights and sounds of the world around me. I’m a lovable companion seeking a special home where I’ll be a cherished member of the family. With bright eyes and a precious face, I have a beautiful personality to match.   

 

Type of home I’m looking for: A home where I will be an indoor bunny and a cherished member of the family.

18 Pixie Dog Toy Poodle cross 8 yrs F White Whether we snuggle on the couch or enjoy a day at the park, I’m at home as long as I’m with you. I’m a great student! You will be amazed by how quickly I learn new tricks. I’m an adorable lap-dog who loves to snuggle with my people friends.    

 

Type of home I’m looking for: I will do best in a home where I am the only pet in your life, and I prefer an adults-only home.

19 Rocky Dog Shepherd cross 6 yrs M Tan/Black I enjoy relaxing, sleeping and snuggling by the side of a companion or a warm window. While I enjoy spending quality time with my people friends, I am also content to spend time on my own. I have an independent spirit. I’m a mellow and easy-going companion, content just to feel loved.   

 

Type of home I’m looking for: I will enjoy life in a home with older children.

SELECT Pets.ID, Pets.PetName, Pets.Type, Pets.Breed, Pets.[Age], Pets.Gender, Pets.Color, Pets.Details
FROM Pets LEFT JOIN Owner ON Pets.[FKOwnerID] = Owner.[OwnerID]
WHERE (((Owner.OwnerID) Is Null));

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality