ACCESS 2013 Project

Customers

CustomerID AG01

FirstName Antonio LastName Gonzalez

StreetAddress 702 Columbia Road

City West Palm Beach 33403

Phone (561) 555-9361

ZipCode

Newsletter

CustomerID AW01

FirstName Anthony LastName Willett

StreetAddress 1274 Valley Street

City West Palm Beach 33412

Phone (561) 555-7939

ZipCode

Newsletter

CustomerID BG01

FirstName Bruce LastName Garber

StreetAddress 1107 Murry Street

City Ft. Lauderdale 33312

Phone (954) 555-4473

ZipCode

Newsletter

SO LU

TI O N

SA M

PL E

Sales

SaleDate 6/30/2013

LastName Duron

FirstName David

PetID 208636

Price $180.00

AnimalType Dog

Phone (561) 555-5510

Breed Siberian Husky

MainColor Gray

AgeInMonths 3

SaleDate 6/1/2013

LastName Alleyne

FirstName Joe

PetID 144601

Price $50.00

AnimalType Cat

Phone (305) 555-3748

Breed Bengal

MainColor Brown

AgeInMonths 3

SaleDate 6/1/2013

LastName Bettencourt

FirstName Juan

PetID 147883

Price $95.00

AnimalType Dog

Phone (561) 555-4509

Breed Fox Terrier

MainColor White

AgeInMonths 5

SaleDate 6/1/2013

LastName Bocanegra

FirstName Melinda

PetID 208636

Price $180.00

AnimalType Dog

Phone (305) 555-5648

Breed Siberian Husky

MainColor Gray

AgeInMonths 3

SaleDate 6/20/2013

LastName Brown

FirstName Dale

PetID 236936

Price $135.00

AnimalType Dog

Phone (561) 555-2312

SO LU

TI O N

SA M

PL E

SO LU

TI O N

SA M

PL E

Pet Inventory Report

AnimalType Breed MainColor AgeInMonths PricePetID

Cat

Persian White 4 $100.00678221

American Shorthair Calico 2 $20.00466448

Bengal Brown 3 $50.00144601

Himalayan White 5 $60.00571764

American Shorthair Black 4 $20.00599703

Turkish Angora White 3 $95.00451472

Siamese Beige 4 $35.00267349

American Bobtail Brown Tabby 4 $30.00520691

Scottish Fold Gray 4 $75.00718056

American Shorthair Orange Tabby 2 $20.00763290

Manx Gray Tabby 3 $50.00796859

American Shorthair Silver Tabby 3 $20.00797129

Maine Coon Gray Tabby 3 $75.00858070

Savannah Beige Tabby 5 $105.00661399

3.5

Dog

Bull Terrier White 3 $135.00236936

Siberian Husky Gray 3 $180.00208636

Yorkshire Terrier Brown 4 $120.00308359

Pomeranian Beige 3 $145.00366426

Fox Terrier White 5 $95.00147883

American Eskimo Dog White 5 $220.00382848

Chihuahua Brown 4 $90.00412745

Boxer Beige 3 $210.00453557

Poodle White 4 $75.00458263

Bloodhound Brown 4 $165.00519192

Cocker Spaniel Beige 3 $145.00910387

Irish Setter Brown 5 $175.00665054

Golden Retriever Beige 5 $180.00723951

Old English Sheepdog White 4 $175.00831176

Page 1

SO LU

TI O N

SA M

PL E

AnimalType Breed MainColor AgeInMonths PricePetID

Giant Schnauzer Black 4 $110.00883940

Dachshund Brown 3 $105.00495646

3.875

3.7

Page 2

SO LU

TI O N

SA M

PL E

Detailed Sales Report

PetIDSaleDate LastName FirstName Phone AnimalType Breed Price

June 2013

451472Gonzalez Antonio (561) 555-9361 Cat Turkish Angora $95.006/5/2013

144601Alleyne Joe (305) 555-3748 Cat Bengal $50.006/1/2013

147883Bettencourt Juan (561) 555-4509 Dog Fox Terrier $95.006/1/2013

208636Bocanegra Melinda (305) 555-5648 Dog Siberian Husky $180.006/1/2013

236936Brown Dale (561) 555-2312 Dog Bull Terrier $135.006/20/2013

267349Diggs Steve (954) 555-1017 Cat Siamese $35.006/20/2013

366426Diggs Steve (954) 555-1017 Dog Pomeranian $145.006/20/2013

382848Fredette Caroline (561) 555-0634 Dog American Eskimo Dog $220.006/4/2013

208636Duron David (561) 555-5510 Dog Siberian Husky $180.006/30/2013

$1,135.00

July 2013

520691Weldon Jeffery (954) 555-6243 Cat American Bobtail $30.007/4/2013

520691Hartzell Heidi (954) 555-3859 Cat American Bobtail $30.007/17/2013

Page 1

SO LU

TI O N

SA M

PL E

PetIDSaleDate LastName FirstName Phone AnimalType Breed Price

661399Elson Philip (305) 555-1028 Cat Savannah $105.007/24/2013

718056Rand Russell (561) 555-2958 Cat Scottish Fold $75.007/14/2013

520691Weldon Jeffery (954) 555-6243 Cat American Bobtail $30.007/4/2013

519192Alleyne Joe (305) 555-3748 Dog Bloodhound $165.007/14/2013

$435.00

August 2013

858070Zhou Min (954) 555-4386 Cat Maine Coon $75.008/1/2013

831176Rayner Ronald (561) 555-1141 Dog Old English Sheepdog $175.008/14/2013

678221Sager Charlotte (305) 555-2879 Cat Persian $100.008/1/2013

661399Walk Thomas (954) 555-9960 Cat Savannah $105.008/4/2013

910387Numbers Marvin (954) 555-4366 Dog Cocker Spaniel $145.008/15/2013

$600.00

$2,170.00

Page 2

SO LU

TI O N

SA M

PL E