Categories

CategoryID CategoryName Description

1 Beverages Soft drinks, coffees, teas, beers, and ales
2 Condiments Sweet and savory sauces, relishes, spreads, and seasonings
3 Confections Desserts, candies, and sweet breads
4 Dairy Products Cheeses
5 Grains/Cereals Breads, crackers, pasta, and cereal
6 Meat/Poultry Prepared meats
7 Produce Dried fruit and bean curd
8 Seafood Seaweed and fish
9 Bebidas Bebidas

Page 1
 Products

ProductID ProductName SupplierID CategoryID QuantityPerUnit UnitPrice

1 Chai 1 1 10 boxes x 20 bags $18.00
2 Chang 1 1 24 - 12 oz bottles $19.00
3 Aniseed Syrup 1 2 12 - 550 ml bottles $10.00
4 Chef Anton's Cajun 2 2 48 - 6 oz jars $22.00
5 Chef Anton's Gumbo 2 2 36 boxes $21.35
6 Grandma's Boysenbe 3 2 12 - 8 oz jars $25.00
7 Uncle Bob's Organic 3 7 12 - 1 lb pkgs. $30.00
8 Northwoods Cranber 3 2 12 - 12 oz jars $40.00
9 Mishi Kobe Niku 4 6 18 - 500 g pkgs. $97.00
10 Ikura 4 8 12 - 200 ml jars $31.00
11 Queso Cabrales 5 4 1 kg pkg. $21.00
12 Queso Manchego La 5 4 10 - 500 g pkgs. $38.00
13 Konbu 6 8 2 kg box $6.00
14 Tofu 6 7 40 - 100 g pkgs. $23.25
15 Genen Shouyu 6 2 24 - 250 ml bottles $15.50
16 Pavlova 7 3 32 - 500 g boxes $17.45
17 Alice Mutton 7 6 20 - 1 kg tins $39.00
18 Carnarvon Tigers 7 8 16 kg pkg. $62.50
19 Teatime Chocolate Bi 8 3 10 boxes x 12 pieces $9.20
20 Sir Rodney's Marmal 8 3 30 gift boxes $81.00
21 Sir Rodney's Scones 8 3 24 pkgs. x 4 pieces $10.00
22 Gustaf's Knäckebröd 9 5 24 - 500 g pkgs. $21.00
23 Tunnbröd 9 5 12 - 250 g pkgs. $9.00
24 Guaraná Fantástica 10 1 12 - 355 ml cans $4.50
25 NuNuCa Nuß-Nouga 11 3 20 - 450 g glasses $14.00
26 Gumbär Gummibärc 11 3 100 - 250 g bags $31.23
27 Schoggi Schokolade 11 3 100 - 100 g pieces $43.90
28 Rössle Sauerkraut 12 7 25 - 825 g cans $45.60
29 Thüringer Rostbratw 12 6 50 bags x 30 sausgs. $123.79
30 Nord-Ost Matjesheri 13 8 10 - 200 g glasses $25.89
31 Gorgonzola Telino 14 4 12 - 100 g pkgs $12.50
32 Mascarpone Fabioli 14 4 24 - 200 g pkgs. $32.00
33 Geitost 15 4 500 g $2.50
34 Sasquatch Ale 16 1 24 - 12 oz bottles $14.00
35 Steeleye Stout 16 1 24 - 12 oz bottles $18.00
36 Inlagd Sill 17 8 24 - 250 g jars $19.00
37 Gravad lax 17 8 12 - 500 g pkgs. $26.00
38 Côte de Blaye 18 1 12 - 75 cl bottles $263.50
39 Chartreuse verte 18 1 750 cc per bottle $18.00
40 Boston Crab Meat 19 8 24 - 4 oz tins $18.40
41 Jack's New England 19 8 12 - 12 oz cans $9.65
42 Singaporean Hokkien 20 5 32 - 1 kg pkgs. $14.00
43 Ipoh Coffee 20 1 16 - 500 g tins $46.00
44 Gula Malacca 20 2 20 - 2 kg bags $19.45
45 Rogede sild 21 8 1k pkg. $9.50
46 Spegesild 21 8 4 - 450 g glasses $12.00
47 Zaanse koeken 22 3 10 - 4 oz boxes $9.50
48 Chocolade 22 3 10 pkgs. $12.75
49 Maxilaku 23 3 24 - 50 g pkgs. $20.00

Page 2
 Products

50 Valkoinen suklaa 23 3 12 - 100 g bars $16.25

51 Manjimup Dried App 24 7 50 - 300 g pkgs. $53.00
52 Filo Mix 24 5 16 - 2 kg boxes $7.00
53 Perth Pasties 24 6 48 pieces $32.80
54 Tourtière 25 6 16 pies $7.45
55 Pâté chinois 25 6 24 boxes x 2 pies $24.00
56 Gnocchi di nonna Al 26 5 24 - 250 g pkgs. $38.00
57 Ravioli Angelo 26 5 24 - 250 g pkgs. $19.50
58 Escargots de Bourgo 27 8 24 pieces $13.25
59 Raclette Courdavault 28 4 5 kg pkg. $55.00
60 Camembert Pierrot 28 4 15 - 300 g rounds $34.00
61 Sirop d'érable 29 2 24 - 500 ml bottles $28.50
62 Tarte au sucre 29 3 48 pies $49.30
63 Vegie-spread 7 2 15 - 625 g jars $43.90
64 Wimmers gute Semm 12 5 20 bags x 4 pieces $33.25
65 Louisiana Fiery Hot 2 2 32 - 8 oz bottles $21.05
66 Louisiana Hot Spice 2 2 24 - 8 oz jars $17.00
67 Laughing Lumberjac 16 1 24 - 12 oz bottles $14.00
68 Scottish Longbreads 8 3 10 boxes x 8 pieces $12.50
69 Gudbrandsdalsost 15 4 10 kg pkg. $36.00
70 Outback Lager 7 1 24 - 355 ml bottles $15.00
71 Flotemysost 15 4 10 - 500 g pkgs. $21.50
72 Mozzarella di Giova 14 4 24 - 200 g pkgs. $34.80
73 Röd Kaviar 17 8 24 - 150 g jars $15.00
74 Longlife Tofu 4 7 5 kg pkg. $10.00
75 Rhönbräu Klosterbie 12 1 24 - 0.5 l bottles $7.75
76 Lakkalikööri 23 1 500 ml $18.00
77 Original Frankfurter 12 2 12 boxes $13.00

Page 3
 Products

UnitsInStock UnitsOnOrder ReorderLevel Discontinued

39 0 10 0
17 40 25 0
13 70 25 0
53 0 0 0
0 0 0 -1
120 0 25 0
15 0 10 0
6 0 0 0
29 0 0 -1
31 0 0 0
22 30 30 0
86 0 0 0
24 0 5 0
35 0 0 0
39 0 5 0
29 0 10 0
0 0 0 -1
42 0 0 0
25 0 5 0
40 0 0 0
3 40 5 0
104 0 25 0
61 0 25 0
20 0 0 -1
76 0 30 0
15 0 0 0
49 0 30 0
26 0 0 -1
0 0 0 -1
10 0 15 0
0 70 20 0
9 40 25 0
112 0 20 0
111 0 15 0
20 0 15 0
112 0 20 0
11 50 25 0
17 0 15 0
69 0 5 0
123 0 30 0
85 0 10 0
26 0 0 -1
17 10 25 0
27 0 15 0
5 70 15 0
95 0 0 0
36 0 0 0
15 70 25 0
10 60 15 0

Page 4
 Products

65 0 30 0
20 0 10 0
38 0 25 0
0 0 0 -1
21 0 10 0
115 0 20 0
21 10 30 0
36 0 20 0
62 0 20 0
79 0 0 0
19 0 0 0
113 0 25 0
17 0 0 0
24 0 5 0
22 80 30 0
76 0 0 0
4 100 20 0
52 0 10 0
6 10 15 0
26 0 15 0
15 10 30 0
26 0 0 0
14 0 0 0
101 0 5 0
4 20 5 0
125 0 25 0
57 0 20 0
32 0 15 0

Page 5
 Suppliers

SupplierID CompanyName ContactName ContactTitle Address City Region

1 Exotic Liquids Charlotte Cooper Purchasing Manage49 Gilbert St. London
2 New Orleans Cajun DelShelley Burke Order AdministratoP.O. Box 7893New OrleanLA
3 Grandma Kelly's HomeRegina Murphy Sales Representati 707 Oxford RdAnn Arbor MI
4 Tokyo Traders Yoshi Nagase Marketing Manage9-8 Sekimai MTokyo
5 Cooperativa de QuesosAntonio del Valle S Export AdministratCalle del RosaOviedo Asturias
6 Mayumi's Mayumi Ohno Marketing Represen 92 Setsuko ChOsaka
7 Pavlova, Ltd. Ian Devling Marketing Manage74 Rose St. MMelbourne Victoria
8 Specialty Biscuits, Ltd.Peter Wilson Sales Representati 29 King's WayManchester
9 PB Knäckebröd AB Lars Peterson Sales Agent Kaloadagatan Göteborg
10 Refrescos Americana Carlos Diaz Marketing ManageAv. das AmeriSao Paulo
11 Heli Süßwaren GmbH Petra Winkler Sales Manager Tiergartenstra Berlin
12 Plutzer Lebensmittelg Martin Bein International MarkBogenallee 51Frankfurt
13 Nord-Ost-Fisch HandelSven Petersen Coordinator Forei Frahmredder 1Cuxhaven
14 Formaggi Fortini s.r.l. Elio Rossi Sales Representati Viale Dante, 7Ravenna
15 Norske Meierier Beate Vileid Marketing ManageHatlevegen 5 Sandvika
16 Bigfoot Breweries Cheryl Saylor Regional Account 3400 - 8th AveBend OR
17 Svensk Sjöföda AB Michael Björn Sales Representati BrovallavägenStockholm
18 Aux joyeux ecclésiasti Guylène Nodier Sales Manager 203, Rue des Paris
19 New England Seafood Robb Merchant Wholesale AccountOrder ProcessiBoston MA
20 Leka Trading Chandra Leka Owner 471 SerangoonSingapore
21 Lyngbysild Niels Petersen Sales Manager Lyngbysild Fi Lyngby
22 Zaanse Snoepfabriek Dirk Luchte Accounting ManagVerkoop Rijn Zaandam
23 Karkki Oy Anne Heikkonen Product Manager Valtakatu 12 Lappeenranta
24 G'day, Mate Wendy Mackenzie Sales Representati 170 Prince Edw Sydney NSW
25 Ma Maison Jean-Guy Lauzon Marketing Manage2960 Rue St. LMontréal Québec
26 Pasta Buttini s.r.l. Giovanni Giudici Order AdministratoVia dei GelsomSalerno
27 Escargots Nouveaux Marie Delamare Sales Manager 22, rue H. VoiMontceau
28 Gai pâturage Eliane Noz Sales Representati Bat. B 3, rue Annecy
29 Forêts d'érables Chantal Goulet Accounting Manag148 rue Chass Ste-HyacinQuébec

Page 6
 Suppliers

PostalCode Country Phone Fax HomePage

EC1 4SD UK (171) 555-2222
70117 USA (100) 555-4822 #CAJUN.HTM#
48104 USA (313) 555-5(313) 555-3349
100 Japan (03) 3555-5011
33007 Spain (98) 598 76 54
545 Japan (06) 431-7877 Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleap
3058 Australia (03) 444-23(03) 444-6588
M14 GSD UK (161) 555-4448
S-345 67 Sweden 031-987 65 031-987 65 91
5442 Brazil (11) 555 4640
10785 Germany (010) 9984510
60439 Germany (069) 992755 Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps
27478 Germany (04721) 871(04721) 8714
48100 Italy (0544) 6032(0544) 606 #FORMAGGI.HTM#
1320 Norway (0)2-953010
97101 USA (503) 555-9931
S-123 45 Sweden 08-123 45 67
75004 France (1) 03.83.00(1) 03.83.00.62
02134 USA (617) 555-3(617) 555-3389
0512 Singapore 555-8787
2800 Denmark 43844108 43844115
9999 ZZ Netherlands (12345) 121(12345) 1210
53120 Finland (953) 10956
2042 Australia (02) 555-59(02) 555-4 G'day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sample
H1J 1C3 Canada (514) 555-9022
84100 Italy (089) 65476(089) 6547667
71300 France 85.57.00.07
74000 France 38.76.98.0638.76.98.58
J2S 7S8 Canada (514) 555-2(514) 555-2921

Page 7
 Suppliers

.microsoft.com/accessdev/sampleapps/mayumi.htm#

crosoft.com/accessdev/sampleapps/plutzer.htm#

w.microsoft.com/accessdev/sampleapps/gdaymate.htm#

Page 8