Order Now

microsoft access – animal hospital database

6 min read
Posted on 
November 9th, 2022
Home microsoft access - animal hospital database

Create the following queries using the

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

animal hospital database

(see attached document) Please make sure my query’s are correct – if not please re-do them.

Query1: Get the AnimalID, Breed, AnimalName of all the dogs who are 3 years old.  

Query2: Get the number of animal visits by each animal (AnimalID).

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Hint: You can refer to database lab tutorial query 10 for the use of Totals.

Query3: Get the first name and last name of all the clients whose first name starts with letter B or whose last name contains letter e.

Hint: You can refer to database lab tutorial query 3 for the use of wildcard character.

Query4: Get the AnimalID and Names of the animals who had at least two visits with Doctor Hopkins.

Query5: For each ClientID, get the total balance that the client still needs to pay for all the visits together. The balance for each visit is calculated as the difference between Fee and Paid.

Hint: For calculating the balance, you may refer to database lab tutorial query 12 for the use of [ ], etc.

1

2

3 2

4 3 Cat Mix

4 Dog Mix 5

6 5 Dog

6

6

4

8 6

7

6 Cow Herford 8

7 Horse

11 8 Dog

6

9 Dog

5

10 Cat

4

11

3

12

2

13 Horse

9

13 Horse Saddlebred 8

14 Cat Mix 4

15 Cat Mix 7

16 Dog Mix 6

17 Dog Mix 5

18 Dog Collie 10

19 Dog Chihuahua 5

19 Cat

6

20 Dog Terrier 4

21 Cat Mix 8

22 Cat Persian 6

23 Dog Terrier 4

24

6

25 Dog Mix 2

25 Cat Mix 1

25 Cat Mix 1

25 Cat Persian 7

26

2

27 Dog Mix 4

28 Cat Mix 5

29 Cat Mix 1

30 Dog Doberman 6

31 Dog Collie 7

32 Cat Mix 8

33 Horse Saddlebred 4

33 Horse Morgan 1

33 Horse Quarterhorse 8

34 Cat Mix 3

34 Cat Mix 5 Fluffy

35 Dog Mix 6

36 Horse Mix 7

37 Llama 4

38 Hog 2

39 Dog

6

40 Dog

4

41 Cat Mix 6

42 Cat Mix 1

43 Dog

9

44 Horse

4

44 Horse Quarterhorse 9

6 Cow

1

26 Cow

3

37

1

26 Cow Angus 1

40 Dog

1

AnimalID ClientID Species Breed Age AnimalName
1 Horse Quarterhorse 4 Blaze
2 Dog Chihuahua 3 Spot
Cat Mix 6 Nirmal
8 Big
5 Rover
Collie Sarah
7 Goat Nubian
Cow Herford
9
10 Morgan 11 Isty
Doberman Jake
12 Terrier Curley
13 Manx Little
14 Llama Matisse
15 Hog Petunia
16 Saddlebred Chug
17 Lightning
18 Garfield
19 Mittens
20 Bozo
21 Butler
22 Shadow
23 Stimpy
24 Persian Queenie
25 Zippo
26 Jimbo
27 Sheba
28 Groucho
29 Sheep
30 Hero
31 Bartholemew
32 Skippy
33 Jezebel
34 Ostrich Blue
35 Fluffy
36 Tiger
37 Sunshine
38 Friendly
39 Lady
40 Rainbow
41 Stonewall
42 Double Trouble
43 Lucky
44 Puffy
45
46 Tramp
47 Sport
48 Inca
49
50 Poodle Alphonse
51 Blue Heeler Beowolf
52 Bert
53 Ernie
54 Spaniel Rex
55 Pony Daisy
56 Jackson
57 Angus
58 Holstein
59 Emu Standard
60
61 Labrador Harley
ClientID

1

2

0 Wiltshire Blvd

Cawston

false

3

Cawston

4

true

5

Cawston

false

6

Cawston

false

7

Cawston

true

8

false

9

false

10

Seymour

false

11

Cawston

false

12

Cawston

true

13

Cawston

false

14

Brookwood

false

15

Cawston

false

16

Cawston

false

17

Seymour

false

18

Cawston

false

19

Cawston

false

20

Brookwood

false

21

Cawston

true

22

Cawston

false

23

Cawston

false

24

Abbot

true

25

Cawston

false

26

Cawston

false

27

Cawston 441-6655 false

28

Cawston

false

29

Brookwood

false

30

Cawston

true

31

Cawston

false

32

Cawston

false

33

Cawston

false

34

Cawston

false

35

Cawston

false

36

Cawston

false

37

Cawston

false

38

Cawston

false

39

Butler

Cawston

true

40

Cawston

true

41

Cawston

false

42

Cawston

false

43

Cawston

false

44

Cawston

false

ClientFirstName ClientLastName ClientAddress ClientCity ClientPhone Account
Jennifer Logan 324 Eastside Ave Cawston 456-5443 false
Ken London 90 456-3154
Britt Lizette 14-3214 27 Avenue 654-8852 true
Diana Stapleton 5232 Ida Road Seymour 441-6532
Lloyd Ray 124 E. 39 Street 332-9090
Duane Terrace 44-9090 Salmon St 123-9960
Bruce Moore 670 Monteith Rd 334-0987
Dennis Williams 5512 Lakeside Drive Brookwood 454-6622
Wayne Moravec RR1 Yankee Flats Abbot 434-0980
Pattie Dene 4403 Ida Road 441-6655
Gregory Paulette 775 39 Street 332-1505
Owen Belgo 8770 Delhart Ave 235-6541
Kevin Pavan 441 Potter Drive 551-6622
Wendy Schneider 133 Buckland St 441-6023
Carl Herbert 902 Uplands Drive 551-6327
Stephanie Michael 443 Shelley Ave 665-9977
Jakob Schmidt 775 Ida Road 442-5102
Pam Stebner 345 Wiltshire Blvd 455-6632
Ingrid Corey 22-4587 42 Ave 125-6545
Leanne Stein 220 Lakeside Drive 554-6500
Carmen Vallance 451-6625 38 St 451-3352
Lorne Valliere 545 Potter Drive 554-3652
Gerald Vanderburg 21 Eastside Ave 456-3211
Hank Gallagher RR3 Yankee Flats 225-6333
Elizabeth Norman 554 Cascade Pl 445-6632
Ron Widmann 756 Clara Drive 252-6411
Lonnie Wilkins 141 Uplands Drive
Roland Sherwood 712 Shannon Way 225-5544
Bud Charming 8805 Lakeside Drive 564-3332
Arnie Cramer 2061 Buchanan 455-6001
Nick Donnelly 123 Shelley Ave 665-3324
Timothy Collins 4456 Delhart Ave 255-3685
Allan Young 767 Renfrew St 124-9987
Joan Clements 213 Potter Drive 665-4422
Graham Sanderson 4305 Beach Ave 445-3328
Barry Desjardins 206 14 Avenue 332-6410
Linda Burke 477 Canyon Drive 124-6654
Darren James 62 Eastside Ave 456-1102
Spence 855 Downie 335-6410
Lyle Adair 332 Ackerman Drive 441-6320
Dorothy Clifford 365-6630 38 St 451-6701
Jose Zurba 66 Cranbrooke Rd 225-3001
Lorna Peterson 201 14 Avenue 332-5413
Brendan Woods 233 Yuma St 441-2235
1

2

3

4

5

6

7

DoctorID DoctorName HomePhone
Dvorak 554-6684
Jesse 665-8744
Hopkins 441-6060
Lamaze 250-6300
Wilson 441-6544
Smith 992-2344
Chen 323-3456

AnimalID DoctorID

1 1 45

true

2 1 30 Prescription

¤ 20.00 false

2 4 60

¤ 150.00 false

5/21/99 3 1 15

¤ 25.00 false

5/20/99 4 5 45

¤ 30.00 false

5 3 45

¤ 40.00

false

5/20/99 5 1 45 Prescription ¤ 35.00 ¤ 20.00 true

5 1 45 Prescription ¤ 35.00 ¤ 20.00 true

5/23/99 5 1 30 First Aid

¤ 45.00 false

5/22/99 6 1 30 Prescription ¤ 40.00 ¤ 40.00 false
5/19/99 7 2 45 First Aid ¤ 40.00 ¤ 0.00 false
5/19/99 8 2 15

¤ 20.00

true

5/20/99 8 5 45 Miscellaneous ¤ 30.00 ¤ 30.00 false
5/22/99 8 5 45 Miscellaneous ¤ 30.00 ¤ 30.00 false
5/21/99 9 2 90 Surgery

¤ 0.00 true

5/19/99 10 5 60 Surgery

¤ 175.00 true

5/21/99 10 1 30

¤ 55.00 true

5/22/99 10 1 15 Check-up ¤ 25.00 ¤ 25.00 true
5/23/99 10 3 30 Prescription ¤ 40.00 ¤ 0.00 true

11 3 45 First Aid

¤ 50.00 false

5/20/99 11 3 90 Surgery

false

5/21/99 11 5 15 Check-up ¤ 25.00 ¤ 25.00 false
5/22/99 12 5 15 Consultation ¤ 20.00 ¤ 20.00 false
5/22/99 13 4 30 Prescription ¤ 40.00 ¤ 40.00 false
5/18/99 14 4 30 Vaccination ¤ 45.00 ¤ 10.00 true
5/20/99 14 5 60 Check-up ¤ 55.00 ¤ 55.00 true
5/18/99 15 5 45 First Aid ¤ 50.00 ¤ 50.00 false
5/19/99 15 1 60 Surgery

¤ 100.00 false

5/20/99 15 3 90 Surgery ¤ 225.00 ¤ 100.00 false
5/22/99 15 3 90 Surgery ¤ 225.00 ¤ 100.00 false
5/23/99 15 5 45 First Aid ¤ 50.00 ¤ 50.00 false
5/18/99 16 1 60 Surgery ¤ 150.00 ¤ 0.00 true
5/19/99 16 2 45 Prescription ¤ 40.00 ¤ 40.00 true
5/20/99 16 3 45 First Aid

¤ 35.00 true

5/18/99 17 1 60 Check-up ¤ 55.00 ¤ 55.00 true
5/23/99 17 5 60 First Aid ¤ 60.00 ¤ 0.00 true
5/18/99 18 3 30 Vaccination ¤ 45.00 ¤ 10.00 true
5/20/99 18 5 60 Check-up ¤ 55.00 ¤ 55.00 true
5/22/99 18 3 15 Check-up ¤ 25.00 ¤ 25.00 false
5/23/99 18 4 30 Vaccination ¤ 45.00 ¤ 10.00 true
5/18/99 19 5 15 Check-up ¤ 25.00 ¤ 0.00 false
5/20/99 19 4 60 Surgery ¤ 175.00

false

5/18/99 20 1 60 Surgery ¤ 150.00 ¤ 0.00 true
5/20/99 20 3 45 First Aid ¤ 60.00 ¤ 35.00 true
5/22/99 20 3 15 Check-up ¤ 25.00 ¤ 25.00 false
5/23/99 20 1 60 Surgery ¤ 150.00 ¤ 0.00 true
5/18/99 21 1 60 Check-up ¤ 55.00 ¤ 55.00 true
5/20/99 21 4 30 Prescription ¤ 40.00 ¤ 40.00 false
5/23/99 21 1 60 Check-up ¤ 55.00 ¤ 55.00 true
5/19/99 22 4 30 Miscellaneous ¤ 30.00

false

5/20/99 22 3 30 First Aid ¤ 50.00 ¤ 25.00 false
5/21/99 22 3 30 Vaccination ¤ 50.00 ¤ 0.00 false
5/23/99 22 2 45 First Aid ¤ 40.00 ¤ 40.00 false
5/18/99 23 1 15 Check-up ¤ 25.00 ¤ 0.00 false
5/20/99 23 4 60 Surgery ¤ 175.00 ¤ 75.00 false
5/22/99 23 4 60 Surgery ¤ 175.00 ¤ 75.00 false
5/23/99 23 5 15 Check-up ¤ 25.00 ¤ 0.00 false
5/21/99 24 3 30 Check-up ¤ 45.00 ¤ 45.00 false
5/18/99 25 4 30 First Aid ¤ 50.00 ¤ 50.00 false
5/20/99 25 4 60 Surgery ¤ 150.00 ¤ 50.00 false
5/22/99 25 4 30 Prescription ¤ 40.00 ¤ 40.00 false
5/20/99 26 2 30 First Aid ¤ 45.00 ¤ 20.00 false
5/22/99 26 3 30 First Aid ¤ 50.00 ¤ 25.00 false
5/18/99 27 1 15 Check-up ¤ 25.00 ¤ 0.00 false
5/21/99 27 4 15 Check-up ¤ 25.00 ¤ 15.00 false
5/23/99 27 1 15 Check-up ¤ 25.00 ¤ 0.00 false
5/21/99 28 5 45 First Aid ¤ 40.00 ¤ 40.00 false
5/18/99 29 4 30 First Aid ¤ 50.00 ¤ 50.00 false
5/19/99 29 4 30 Prescription ¤ 40.00 ¤ 40.00 false
5/20/99 29 4 60 Surgery ¤ 150.00 ¤ 50.00 false
5/22/99 29 4 60 Surgery ¤ 150.00 ¤ 50.00 false
5/23/99 29 4 30 First Aid ¤ 50.00 ¤ 50.00 false
5/19/99 30 4 60 Surgery ¤ 150.00 ¤ 150.00 false
5/20/99 30 2 30 First Aid ¤ 45.00 ¤ 20.00 false
5/22/99 30 2 30 First Aid ¤ 45.00 ¤ 20.00 false
5/21/99 31 5 45 First Aid ¤ 40.00 ¤ 20.00 false
5/22/99 32 4 30 Miscellaneous ¤ 45.00 ¤ 10.00 false
5/20/99 33 2 60 Surgery ¤ 175.00 ¤ 175.00 false
5/19/99 34 3 15 Consultation ¤ 20.00 ¤ 0.00 true
5/20/99 35 1 45 Prescription ¤ 40.00 ¤ 40.00 false
5/20/99 36 2 60 Consultation ¤ 50.00 ¤ 25.00 false
5/20/99 37 3 45 Prescription ¤ 40.00 ¤ 40.00 false
5/22/99 37 2 60 Surgery ¤ 175.00 ¤ 175.00 false
5/19/99 38 4 30 Prescription ¤ 40.00 ¤ 40.00 false
5/20/99 39 1 45 Prescription ¤ 40.00 ¤ 40.00 false
5/21/99 39 3 30 Miscellaneous ¤ 30.00 ¤ 30.00 false
5/22/99 39 1 45 Prescription ¤ 40.00 ¤ 40.00 false
5/19/99 40 1 15 Check-up ¤ 25.00 ¤ 20.00 false
5/20/99 40 2 60 Consultation ¤ 50.00 ¤ 25.00 false
5/22/99 40 2 60 Consultation ¤ 50.00 ¤ 25.00 false
5/20/99 41 5 45 First Aid ¤ 40.00 ¤ 40.00 true
5/22/99 41 3 45 Prescription ¤ 40.00 ¤ 40.00 false
5/21/99 42 2 60 Surgery ¤ 175.00 ¤ 100.00 true
5/19/99 43 5 90 Surgery

true

5/18/99 44 2 30 First Aid ¤ 45.00 ¤ 0.00 false
5/20/99 45 5 45 First Aid ¤ 40.00 ¤ 40.00 true
5/22/99 45 1 45 Prescription ¤ 30.00 ¤ 15.00 false
5/22/99 46 2 60 Surgery ¤ 150.00 ¤ 100.00 false
5/22/99 47 4 15 Check-up ¤ 25.00 ¤ 0.00 true
5/18/99 48 2 30 First Aid ¤ 45.00 ¤ 0.00 false
5/22/99 48 5 45 Prescription ¤ 40.00 ¤ 40.00 true
5/23/99 48 2 30 First Aid ¤ 45.00 ¤ 0.00 false
5/22/99 49 3 30 Prescription ¤ 40.00 ¤ 15.00 false
5/21/99 50 4 15 Check-up ¤ 25.00

false

5/22/99 51 1 30 Vaccination ¤ 45.00 ¤ 45.00 false
5/22/99 52 5 90 Surgery

¤ 250.00 false

5/22/99 53 4 15 Consultation ¤ 20.00 ¤ 20.00 false
5/18/99 54 2 30 Check-up ¤ 45.00 ¤ 45.00 false
5/18/99 58 2 30 Check-up ¤ 45.00 ¤ 45.00 false
5/23/99 58 2 30 Check-up ¤ 45.00 ¤ 45.00 false
5/23/99 59 3 45 First Aid ¤ 50.00 ¤ 0.00 true
5/23/99 60 3 30 Vaccination ¤ 55.00 ¤ 55.00 true
5/23/99 61 4 15 Vaccination ¤ 35.00 ¤ 35.00 false
Date Duration Treatment Fee Paid Travel
5/20/99 Prescription ¤ 35.00 ¤ 20.00
5/21/99 ¤ 40.00
5/23/99 Surgery ¤ 150.00
Check-up ¤ 25.00
Miscellaneous ¤ 30.00
5/19/99 First Aid ¤ 0.00
5/22/99
¤ 45.00
Consultation ¤ 10.00
¤ 300.00
¤ 175.00
Vaccination ¤ 55.00
5/18/99 ¤ 50.00
¤ 225.00 ¤ 100.00
¤ 160.00
¤ 60.00
¤ 75.00
¤ 15.00
¤ 350.00 ¤ 200.00
¤ 12.00
¤ 250.00

SELECT Animals.AnimalID, Animals.Breed, Animals.AnimalName, Animals.Age
FROM Animals
WHERE (((Animals.Age)>3));
SELECT Animals.Species, Sum(Visits.AnimalID) AS SumOfAnimalID
FROM Animals INNER JOIN Visits ON Animals.AnimalID = Visits.AnimalID
GROUP BY Animals.Species;
SELECT Clients.ClientFirstName, Clients.ClientLastName
FROM Clients
WHERE (((Clients.ClientFirstName)=”B%”)) OR (((Clients.ClientLastName) Like “*E*”));
SELECT Animals.AnimalID, Animals.AnimalName, Visits.DoctorID, Visits.AnimalID, Doctors.DoctorName
FROM Doctors INNER JOIN (Animals INNER JOIN Visits ON Animals.AnimalID = Visits.AnimalID) ON Doctors.DoctorID = Visits.DoctorID
GROUP BY Animals.AnimalID, Animals.AnimalName, Visits.DoctorID, Visits.AnimalID, Doctors.DoctorName
HAVING (((Visits.DoctorID)=”3″) AND ((Visits.AnimalID)=11 Or (Visits.AnimalID)=15 Or (Visits.AnimalID)=18 Or (Visits.AnimalID)=20 Or (Visits.AnimalID)=22) AND ((Doctors.DoctorName)=”hopkins”));
SELECT Clients.ClientID, Sum(Visits.Fee) AS SumOfFee, Sum(Visits.Paid) AS SumOfPaid
FROM Clients, Visits
GROUP BY Clients.ClientID;

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Calculate the price
Pages (275 words)
$0.00
Paper Answers
Company
Legal
How Our Service is Used:
Paper Answers essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Paper Answers does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2025 Paper Answers. All rights reserved.
Paper Answers will be listed as ‘Paper Answers’ on your bank statement.

Order your essay today and save 30% with the discount code ESSAYHELP

Order Now