View the step-by-step solution to:

Question

please follow docs 1-5work 5.jpg

alt="work 4.jpg" />work 3.jpgwork 2.jpgwork 1.jpg

work 1.jpg

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.

work 2.jpg

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
A

work 3.jpg

BREED PET OWNER PETIS TI PET
OwnerID - "LastName - FirstName - Phone -
Email
- Click to Add -
Downs
Marshall
555-123-6788 [email protected]
2 James
Richard
555-444-0098 [email protected]
3 Frier
Liz
555-444-5596 [email protected]
4 Trent
Miles
555-999-8861 [email protected]
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 search

work 4.jpg

BREED 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
W

work 5.jpg

Sort & 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

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question