Microsoft Access

Lab7StartfileLifesAnimalShelter-04122.accdb

Home >Computer Science homework help >Microsoft Access

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 DISTINCTROW * FROM Owner;

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));

SELECT Count(Pets.PetName) AS CountOfPetName, Pets.Type FROM Pets GROUP BY Pets.Type;

SELECT Pets.Type, Max(Pets.Age) AS MaxOfAge, Min(Pets.Age) AS MinOfAge FROM Pets GROUP BY Pets.Type;

SELECT Count(Pets.[Type]) AS CountOfType, Pets.[Gender] FROM Pets GROUP BY Pets.[Gender];