Microsoft Access query Exercise 1

profilemerckarms
PetsDatabase.accdb
Home>Computer Science homework help>Microsoft Access query Exercise 1
LikesToEatId LikesToEat
1 Tuna
2 Curry
3 Beef
4 Lasagne
5 Leaves
6 Grass
7 Milk
8 Lager
9 Gin and Tonic
10 Pasta
11 Kebab
12 Hot dog
13 Crisps
14 Chocolate
15 Beef burgers
16 BLT
17 Chips
18 Black pudding
19 Ice cream
20 Bananas
21 Guinness
22 Cheese
23 Flies
24 Rice
25 Water
26 Baked beans
27 Omelette
28 Stir fry
29 Sausages
30 Boiled egg
31 People
OwnerId OwnerName OwnerDOB Celebrity?
1 Vicki 1/12/69 true
2 Dean 6/8/57 false
3 Fred Flintstone 12/24/79 true
4 Barney Rubble 6/1/76 true
5 Daffy Duck 11/16/71 true
6 Elmer Fudd 8/2/70 true
7 Bugs Bunny 12/25/60 false
8 Homer Simpson 9/26/67 false
9 Mighty Mouse 4/13/66 true
10 Batman 10/18/75 false
11 Winnie the Pooh 3/13/78 false
12 Tigger 4/26/67 true
13 Piglet 5/21/74 true
14 Robin 10/13/79 true
15 Superman 1/22/66 true
16 Lex Luthor 4/6/58 true
17 Spiderman 1/9/78 false
18 Mr Magoo 8/14/79 false
19 Sylvester 12/28/63 false
20 Huckleberry Hound 10/11/61 true
21 Secret Squirrel 6/27/63 false
22 Yellow Pinky 3/14/79 false
23 BatFink 6/19/75 false
24 Bart Simpson 5/28/63 true
25 Marvin the Martian 11/15/62 false
26 Tazmanian Devil 6/23/73 true
27 Bullwinkle Moose 3/17/68 false
28 Paddington Bear 6/17/60 true
29 Crazylegs Crane 9/22/79 false
30 Felix the Cat 11/21/73 true
31 Popeye 5/9/66 false
32 Tom Cat 5/23/79 false
33 Jerry Mouse 4/5/68 true
34 Porky Pig 10/18/60 false
35 Scooby Doo 10/5/77 true
36 Top Cat 2/13/69 false
37 Snoopy 10/1/64 false
38 Mickey Mouse 3/14/67 false
39 Goofy 3/8/72 false
40 Betty Boop 3/9/70 false
41 Pepe LePew 10/14/60 true
42 Tweety Pie 9/21/58 false
43 Wile E. Coyote 5/12/78 false
44 Pebbles 7/5/71 false
45 Charlie Brown 1/17/66 true
46 Woody Woodpecker 6/20/70 true
47 Chilly Willie 12/2/60 true
48 Donald Duck 3/26/69 false
49 Pink Panther 5/13/69 false
50 Barney Bear 10/17/66 true
51 Boo Boo 2/27/79 false
52 Yogi Bear 12/16/59 true
53 Count Duckula 9/7/65 false
54 Danger Mouse 10/22/74 false
55 Road Runner 1/22/76 true
56 Jessica Rabbit 6/5/66 true
PetId PetName Gender PetDOB Email PetColourId LikesToEatId PetTypeId OwnerId SpecialRequirements VetBills
13 Dai Boy 8/14/96 #mailto:[email protected]# 6 18 3 2 Also loves roast chicken ¤ 25.00
15 Phoebe Girl 7/5/96 #mailto:[email protected]# 3 22 21 3 Likes to eat telephone cables too ¤ 0.00
16 Nancy Girl 10/25/97 #mailto:[email protected]# 7 23 7 8 Hates the French ¤ 36.00
17 Fido Girl 8/1/00 #mailto:[email protected]# 1 3 4 33 ¤ 19.00
18 Arthur Boy 5/4/95 #mailto:[email protected]# 4 31 2 11 Needs his teeth brushing daily ¤ 0.00
21 Boris Boy 11/12/95 #mailto:[email protected]# 6 31 20 3 ¤ 75.00
25 Daphne Girl 9/15/99 #mailto:[email protected]# 2 30 18 7 Also likes lettuce ¤ 0.00
26 Julie Girl 1/12/97 #mailto:[email protected]# 5 28 17 22 ¤ 0.00
27 Andy Boy 4/13/95 #mailto:[email protected]# 17 20 19 51 Needs plenty of water ¤ 0.00
28 Dave Boy 12/19/00 #mailto:[email protected] 16 16 13 53 ¤ 0.00
29 Jenny Girl 1/1/90 #mailto:[email protected]# 7 14 10 40 ¤ 0.00
30 Sandi Girl 12/12/00 #mailto:[email protected]# 1 19 9 23 ¤ 0.00
31 Daisy Girl 9/13/97 #mailto:[email protected]# 4 13 3 2 ¤ 0.00
32 Dorian Girl 2/23/94 #mailto:[email protected]# 9 30 3 10 ¤ 0.00
33 Basil Boy 7/1/99 #mailto:[email protected]# 4 21 8 10 ¤ 0.00
PetColourId PetColour
1 White
2 Black
3 Brown
4 Ginger
5 Pink
6 Red
7 Green
8 Yellow
9 Purple
10 Gold
11 Blue
12 Orange
16 Grey
17 Silver
PetSkinId PetSkin
1 Scaly
2 Furry
3 Smooth
4 Slimy
5 Clammy
6 Revolting
7 Rough
8 Lumpy
9 Spiky
10 Feathery
11 Hairy
PetTypeId PetType PetSkinId Limbs Picture
2 Alligator 1 4
3 Cat 2 4
4 Dog 3 4
5 Horse 4 4
6 Lion 5 4
7 Frog 4 4
8 Fox 7 4
9 Snowman 8 2
10 Tree 8 100
11 Rat 2 4
12 Gerbil 2 4
13 Rock 3 0
14 Snake 3 0
15 Fish 1 3
16 Hamster 2 4
17 Parrot 10 4
18 Slug 6 0
19 Iguana 1 4
20 Spider 6 8
21 Rabbit 11 4
PARAMETERS __OwnerId Value; SELECT DISTINCTROW * FROM Pet AS OwnersOfPetsMainForm WHERE ([__OwnerId] = OwnerId);
PARAMETERS __PetTypeId Value; SELECT DISTINCTROW * FROM Pet AS [PetsOfTypeMainForm 2] WHERE ([__PetTypeId] = PetTypeId);
PARAMETERS __PetTypeId Value; SELECT DISTINCTROW * FROM Pet AS PetsOfTypeMainForm WHERE ([__PetTypeId] = PetTypeId);
PARAMETERS __OwnerId Value; SELECT DISTINCTROW * FROM Pet AS [Types and Pets Main Form] WHERE ([__OwnerId] = OwnerId);