Access MS office

profilelvlupnow
pet_supplies.accdb
Home>Computer Science homework help>Access MS office
Customer Number Company Name Last Name First Name Title Address City State Postal Code Phone Number Fax Number
01 Pets Unlimited Barron Jared Manager 341 Broad Street Tyler TX 75024 (972) 555-1234 (972) 555-1235
10 Cats Exclusively MacDonald John Owner 1928 N Yeller Portland OR 97101 (503) 555-0487 (503) 555-0488
11 Bow Wow Supplies Roberts Dee Dee Manager 2419 Santa Cruz St. San Jose CA 95148 (408) 555-7622
12 Specialty Pets Walden Fred Manager 1720 NW Merchant Aloha OR 97035 (503) 555-2938
13 Anything Goes!! Martinez Eunice Manager 3405 E. Puyallup Lake Texoma TX 75278 (972) 555-5555 (972) 555-5882
14 Southwest Pet Supply Watson Andrea President 18 Rainier NE Tualatin OR 97038 (503) 555-8414 (503) 555-8415
15 Bayview Pet Center Donahue Walter Owner 18 Market St. San Francisco CA 94116 (415) 555-4098 (415) 555-4099
02 Little Animals Hu Randy Manager 444 8th NE Waco TX 75689 (972) 555-1478 (972) 555-1479
03 Pet Palace White Tyrone Manager 1805 8th Street Oakland CA 94608 (409) 555-4449 (409) 555-4459
04 Anne's Pet Supplies Hernandez Anne Owner 2501 La Jolla Blvd. San Diego CA 92111 (619) 555-6719
05 Friendly Groomers Long Herbert Purch Mgr 22 Spruce Way Eugene OR 97403 (503) 555-6644 (503) 555-6655
06 Pet Paradise Hughes Susan Admin Asst 2409 Springer Ave. Bellingham TX 98226 (972) 555-4563 (972) 555-4564
07 Teddy's Pampered Pets Bayer Teddy Owner 1500 Onion Field Way Grand Prarie TX 75236 (509) 555-3462
08 Pets 'n' Such Marley Mary Owner 2500 W. Olympic Blvd. Los Angeles CA 90028 (213) 555-3333 (213) 555-4444
09 My Buddy Pet Supply Ramirez Christine Purch Mgr 2450 J Street Sacramento CA 95831 (916) 555-7675 (916) 555-7676
Product ID Product Description Price Stock on Hand Reorder Point
150 Wonder Diet - Dogs ¤ 11.92 560.0 50
230 Wonder Diet - Cats ¤ 6.26 256.0 85
856 Rawhide Bone - Large ¤ 7.24 985.0 22
547 Rawhide Bone - Medium ¤ 5.24 452.0 32
347 Rawhide Bone - Small ¤ 3.90 145.0 44
532 Groomer Brush ¤ 17.24 985.0 55
318 Silkie Shampoo ¤ 7.86 632.0 100
930 Silkie Conditioner ¤ 5.24 360.0 20
847 Groomer Comb ¤ 22.96 120.0 80
162 Nail Trimmer - Small ¤ 11.03 205.0 50
340 Nail Trimmer - Large ¤ 17.66 963.0 60
323 Linatone for Coats ¤ 17.56 248.0 25
245 Flea Shampoo ¤ 5.62 658.0 15
600 Flea Collar - Dogs, Small ¤ 5.66 125.0 35
925 Flea Collar - Dogs, Large ¤ 9.29 125.0 65
486 Flea Collar - Cats ¤ 3.21 130.0 30
641 Plastic Ball ¤ 1.24 150.0 10
676 Catnip Mouse ¤ 6.35 142.0 20
326 Dog Vitamins ¤ 15.63 77.0 40
417 Cat Vitamins ¤ 14.89 79.0 50
415 Bird Seed - Parakeets ¤ 8.74 36.0 75
574 Bird Seed Mix - Parrots ¤ 12.66 38.0 10
358 Lory Nectar - Small ¤ 5.00 25.0 30
872 Lory Nectar - Large ¤ 10.00 65.0 50
349 Bird Bell ¤ 15.24 65.0 20
599 Plastic Toys - Assorted ¤ 1.99 98.0 80
301 Clippers - Hair ¤ 25.37 56.0 15
Product ID Product Description Price Quantity Customer Number
150 Wonder Diet - Dogs ¤ 11.92 560.0 01
230 Wonder Diet - Cats ¤ 6.26 256.0 02
856 Rawhide Bone - Large ¤ 7.24 985.0 03
547 Rawhide Bone - Medium ¤ 5.24 452.0 04
347 Rawhide Bone - Small ¤ 3.90 145.0 05
532 Groomer Brush ¤ 17.24 985.0 14
318 Silkie Shampoo ¤ 7.86 632.0 03
930 Silkie Conditioner ¤ 5.24 360.0 01
847 Groomer Comb ¤ 22.96 120.0 04
162 Nail Trimmer - Small ¤ 11.03 205.0 02
340 Nail Trimmer - Large ¤ 17.66 963.0 03
323 Linatone for Coats ¤ 17.56 248.0 05
245 Flea Shampoo ¤ 5.62 658.0 03
600 Flea Collar - Dogs, Small ¤ 5.66 125.0 10
925 Flea Collar - Dogs, Large ¤ 9.29 125.0 05
486 Flea Collar - Cats ¤ 3.21 130.0 01
641 Plastic Ball ¤ 1.24 150.0 04
676 Catnip Mouse ¤ 6.35 142.0 02
326 Dog Vitamins ¤ 15.63 77.0 03
417 Cat Vitamins ¤ 14.89 79.0 02
415 Bird Seed - Parakeets ¤ 8.74 36.0 10
574 Bird Seed Mix - Parrots ¤ 12.66 38.0 04
358 Lory Nectar - Small ¤ 5.00 25.0 15
872 Lory Nectar - Large ¤ 10.00 65.0 02
349 Bird Bell ¤ 15.24 65.0 05
599 Plastic Toys - Assorted ¤ 1.99 98.0 13
301 Clippers - Hair ¤ 25.37 56.0 02
162 Nail Trimmer - Large ¤ 11.50 5.0 01
486 Flea Collar - Cats ¤ 3.21 50.0 14
SELECT [Inventory].[Product Description] FROM Inventory ORDER BY [Product Description];
SELECT DISTINCTROW * FROM Customers;
SELECT DISTINCTROW * FROM Inventory;
SELECT DISTINCTROW * FROM Purchases;
SELECT Customers.[Customer Number], Customers.[Company Name], Purchases.[Product ID], Purchases.[Product Description], Purchases.Price, Purchases.Quantity FROM Customers INNER JOIN Purchases ON Customers.[Customer Number] = Purchases.[Customer Number] WHERE (((Customers.[Customer Number])=[Enter Customer ID]));
SELECT Customers.[Customer Number], Customers.[Company Name], Purchases.[Product ID], Purchases.[Product Description], Purchases.Price, Purchases.Quantity FROM Customers INNER JOIN Purchases ON Customers.[Customer Number] = Purchases.[Customer Number] ORDER BY Customers.[Customer Number];
SELECT Inventory.[Product ID], Inventory.[Product Description], Inventory.Price, Inventory.[Stock on Hand] FROM Inventory WHERE (((Inventory.[Stock on Hand])<=50));