Exp19_Access_Ch2_Cap_Foodies.accdb

Products

ProductID	ProductName	SupplierID	CategoryID	QuantityPerUnit	UnitPrice	ProductCost	UnitsInStock	UnitsOnOrder	ReorderLevel	Discontinued
1	Chai	1	1	10 boxes x 20 bags	$18.00	$12.95	39	0	10	FALSE
2	Chang	1	1	24 - 12 oz bottles	$19.00	$13.50	17	40	25	FALSE
3	Aniseed Syrup	1	2	12 - 550 ml bottles	$10.00	$8.40	13	70	25	FALSE
4	Chef Anton's Cajun Seasoning	2	2	48 - 6 oz jars	$22.00	$15.50	53	0	0	FALSE
5	Chef Anton's Gumbo Mix	2	2	36 boxes	$21.35	$18.00	0	0	0	TRUE
6	Grandma's Boysenberry Spread	3	2	12 - 8 oz jars	$25.00	$19.00	120	0	25	FALSE
7	Uncle Bob's Organic Dried Pears	3	7	12 - 1 lb pkgs.	$30.00	$22.50	15	0	10	FALSE
8	Northwoods Cranberry Sauce	3	2	12 - 12 oz jars	$40.00	$28.75	6	0	0	FALSE
9	Mishi Kobe Niku	4	6	18 - 500 g pkgs.	$97.00	$65.00	29	0	0	TRUE
10	Ikura	4	8	12 - 200 ml jars	$31.00	$30.00	31	0	0	FALSE
11	Queso Cabrales	5	4	1 kg pkg.	$21.00	$16.00	22	30	30	FALSE
12	Queso Manchego La Pastora	5	4	10 - 500 g pkgs.	$38.00	$22.75	86	0	0	FALSE
13	Konbu	6	8	2 kg box	$6.00	$2.12	24	0	5	FALSE
14	Tofu	6	7	40 - 100 g pkgs.	$23.25	$15.85	35	0	0	FALSE
15	Genen Shouyu	6	2	24 - 250 ml bottles	$15.50	$9.99	39	0	5	FALSE
16	Pavlova	7	3	32 - 500 g boxes	$17.45	$16.99	29	0	10	FALSE
17	Alice Mutton	7	6	20 - 1 kg tins	$39.00	$20.70	0	0	0	TRUE
18	Carnarvon Tigers	7	8	16 kg pkg.	$62.50	$48.75	42	0	0	FALSE
19	Teatime Chocolate Biscuits	8	3	10 boxes x 12 pieces	$9.20	$4.50	25	0	5	FALSE
20	Sir Rodney's Marmalade	8	3	30 gift boxes	$81.00	$58.80	40	0	0	FALSE
21	Sir Rodney's Scones	8	3	24 pkgs. x 4 pieces	$10.00	$4.50	3	40	5	FALSE
22	Gustaf's Knäckebröd	9	5	24 - 500 g pkgs.	$21.00	$16.90	104	0	25	FALSE
23	Tunnbröd	9	5	12 - 250 g pkgs.	$9.00	$2.75	61	0	25	FALSE
24	Guaraná Fantástica	10	1	12 - 355 ml cans	$4.50	$0.89	20	0	0	TRUE
25	NuNuCa Nuß-Nougat-Creme	11	3	20 - 450 g glasses	$14.00	$8.50	76	0	30	FALSE
26	Gumbär Gummibärchen	11	3	100 - 250 g bags	$31.23	$22.80	15	0	0	FALSE
27	Schoggi Schokolade	11	3	100 - 100 g pieces	$43.90	$22.89	49	0	30	FALSE
28	Rössle Sauerkraut	12	7	25 - 825 g cans	$45.60	$32.50	26	0	0	TRUE
29	Thüringer Rostbratwurst	12	6	50 bags x 30 sausgs.	$123.79	$82.50	0	0	0	TRUE
30	Nord-Ost Matjeshering	13	8	10 - 200 g glasses	$25.89	$12.20	10	0	15	FALSE
31	Gorgonzola Telino	14	4	12 - 100 g pkgs	$12.50	$6.60	0	70	20	FALSE
32	Mascarpone Fabioli	14	4	24 - 200 g pkgs.	$32.00	$14.40	9	40	25	FALSE
33	Geitost	15	4	500 g	$2.50	$2.01	112	0	20	FALSE
34	Sasquatch Ale	16	1	24 - 12 oz bottles	$14.00	$13.51	111	0	15	FALSE
35	Steeleye Stout	16	1	24 - 12 oz bottles	$18.00	$17.51	20	0	15	FALSE
36	Inlagd Sill	17	8	24 - 250 g jars	$19.00	$18.51	112	0	20	FALSE
37	Gravad lax	17	8	12 - 500 g pkgs.	$26.00	$25.51	11	50	25	FALSE
38	Côte de Blaye	18	1	12 - 75 cl bottles	$263.50	$263.01	17	0	15	FALSE
39	Chartreuse verte	18	1	750 cc per bottle	$18.00	$17.51	69	0	5	FALSE
40	Boston Crab Meat	19	8	24 - 4 oz tins	$18.40	$17.91	123	0	30	FALSE
41	Jack's New England Clam Chowder	19	8	12 - 12 oz cans	$9.65	$9.16	85	0	10	FALSE
42	Singaporean Hokkien Fried Mee	20	5	32 - 1 kg pkgs.	$14.00	$13.51	26	0	0	TRUE
43	Ipoh Coffee	20	1	16 - 500 g tins	$46.00	$45.51	17	10	25	FALSE
63	Vegie-spread	7	2	15 - 625 g jars	$43.90	$43.41	24	0	5	FALSE
64	Wimmers gute Semmelknödel	12	5	20 bags x 4 pieces	$33.25	$32.76	22	80	30	FALSE
65	Louisiana Fiery Hot Pepper Sauce	2	2	32 - 8 oz bottles	$21.05	$20.56	76	0	0	FALSE
68	Scottish Longbreads	8	3	10 boxes x 8 pieces	$12.50	$12.01	6	10	15	FALSE
69	Gudbrandsdalsost	15	4	10 kg pkg.	$36.00	$35.51	26	0	15	FALSE
70	Outback Lager	7	1	24 - 355 ml bottles	$15.00	$14.51	15	10	30	FALSE
74	Longlife Tofu	4	7	5 kg pkg.	$10.00	$9.51	4	20	5	FALSE