management information system and app

a01b3Recover.accdb

Home >Business & Finance homework help >Management homework help >management information system and app

CustomerID	CustomerName	Contact	EmailAddress	Address1	Address2	City	State	ZipCode	Phone	Fax	SalesRepID
1	Abel & Young	Jeff Jones		5000 Jefferson Lane	Suite 2000	Miami	FL	33131	3053756442	3053756443	1
2	Department of CIS	Eleanor Milgrom		1238 Walsh Drive	Suite 2202	Miami	FL	33131	3053854431	3053854433	2
3	Advantage Sales	Neil Goodman	[email protected]	4215 South 81 Street		Miami	FL	33131	3054445555	3054445556	1
4	Kinzer & Sons	Nicholas Colon		9020 N.W. 75 Street	Suite 302	Coral Springs	FL	33065	9547539887	9547539888	1
5	Milgrom Associates	Ashley Geoghegan	[email protected]	7500 Center Lane		Coral Springs	FL	33070	9547537830	9547537831	2
7	Bethune Appliance Sales	Michael Ware	[email protected]	276 Brickell Avenue	Suite 1403	Miami	FL	33131	3054443980	3054443981	1
8	Baker Auto Supply	Robert Slane	[email protected]	4508 N.W. 7 Street		Miami	FL	33131	3056353454	3056353455	2
9	Howard Animal Hospital	Luis Couto	[email protected]	455 Bargello Avenue		Coral Gables	FL	33124	3056664801	3056664802	2
10	Katie's Casual Wear	Jeffrey Muddell	[email protected]	9522 S.W. 142 Street		Miami	FL	33176	3052533908	3052533909	1
11	Little, Joiner, & Jones	Lauren Center	[email protected]	7245 NW 8 Street		Miami	FL	33133	3059741234	3059741235	2
12	Kline Bait & Tackle	Benjamin Lee	blee@klineb&t.com	1000 Call Street		Coconut Grove	FL	33133	3053274124	3053274125	2
13	Computer Information Systems	Eleanor Milgrom	[email protected]	1238 Walsh Drove	Suite 2202	Miami	FL	33186	3053854431	3053854433	2
14	Coulter Office Supplies	Maryann Coulter	[email protected]	1000 Main Street		Coral Springs	fl	33071	9541239876		2
26	Lugo Computer Sales	Derek Anderson	[email protected]	6000 Tigertail Avenue		Coconut Grove	FL	33133	3054468900	3054468901	1

OrderID	ProductID	Quantity
1	1	1
1	6	2
2	2	2
2	8	1
2	10	1
3	2	2
3	8	2
3	12	1
4	3	1
4	7	1
4	9	2
4	15	1
5	1	3
6	1	2
6	6	2
6	9	2
7	2	3
7	10	2
7	13	2
8	2	1
8	3	1
9	13	2
9	14	1
9	15	1
10	1	1
10	5	1
10	9	2
11	3	1
11	6	2
11	15	1
12	2	2
13	4	2
13	7	1
13	12	1
14	1	1
14	5	1
14	10	1
14	12	1
14	18	2
15	14	1
15	16	1
15	20	2
15	21	2
16	1	2
16	2	2
16	8	2
16	14	1
17	23	1
18	1	2
18	3	2
18	24	1
19	6	2
19	10	1
19	17	1
20	1	1
20	2	1
20	3	1
21	8	1
21	10	1
21	23	1
22	4	3
23	2	2
23	6	1
23	14	1
23	23	1
24	5	1
25	1	3
25	7	2
25	20	2
25	21	2
26	12	1
26	18	4
27	13	1
27	19	2
27	23	1
28	3	1
28	9	2
28	19	1
29	5	1
29	21	1
30	3	2
30	9	1
30	21	3
31	6	2
31	19	2
31	24	1

OrderID	OrderDate	CustomerID	PaymentType	Comments
1	1/3/12	1	Cash	Will pick up order
2	1/3/12	2	Cash
3	1/5/12	3	Check	Next day delivery
4	1/6/12	4	Credit Card
5	1/6/12	5	Purchase Order	Will pick up order
6	1/6/12	1	Check
7	1/7/12	3	Purchase Order
8	1/10/12	6	Credit Card
9	1/10/12	7	Check	Will pick up order
10	1/11/12	8	Purchase Order	Next day delivery
11	1/11/12	2	Check
12	1/13/12	9	Check	Will pick up order
13	1/13/12	10	Check
14	1/14/12	7	Cash
15	1/14/12	11	Purchase Order
16	1/16/12	11	Credit Card	Will pick up order
17	1/21/12	12	Cash	Next day delivery
18	1/21/12	1	Credit Card
19	1/22/12	2	Check
20	1/23/12	13	Purchase Order
21	1/23/12	14	Purchase Order	Next day delivery
22	1/23/12	8	Cash	Will pick up order
23	1/23/12	6	Credit Card
24	1/24/12	10	Check
25	1/24/12	3	Check
26	1/25/12	4	Purchase Order	Next day delivery
27	1/25/12	5	Check
28	1/25/12	6	Check	Will pick up order
29	1/26/12	10	Cash
30	1/26/12	11	Check
31	1/26/12	14	Cash

ProductID	ProductName	Description	Cost	MarkupPercent	RefrigerationNeeded	Brand	YearIntroduced
1	Coffee - Colombian Supreme	24/Case, Pre-Ground 1.75 Oz Bags	¤ 16.00	0.5	false	Discount	2008.0
2	Coffee - Hazelnut	24/Case, Pre-Ground 1.75 Oz Bags	¤ 23.00	1.0	false	Premium	2009.0
3	Coffee - Mild Blend	24/Case, Pre-Ground 1.75 Oz Bags	¤ 20.00	0.5	false	House	2010.0
4	Coffee - Assorted Flavors	18/Case. Pre-Ground 1.75 Oz Bags	¤ 23.00	0.5	false	House	2011.0
5	Coffee - Decaf	24/Case, Pre-Ground 1.75 Oz Bags	¤ 20.00	0.5	false	Discount	2012.0
6	Tea Bags - Regular	75/Box, Individual Tea Bags	¤ 5.00	0.75	false	House	2008.0
7	Tea Bags - Decaf	75/Box, Individual Tea Bags	¤ 7.00	0.75	false	House	2009.0
8	Creamers - Assorted Flavors	400/Case, 8 50-count Boxes	¤ 20.00	1.0	false	Discount	2010.0
9	Creamers - Liquid	200/Case, Individual Creamers	¤ 15.00	1.0	true	Premium	2011.0
10	Sugar Packets	2000/Case	¤ 18.00	1.0	false	House	2012.0
11	Ceramic Mug	SD Company Logo	¤ 5.00	1.0	false	House	2008.0
12	Sugar Substitute	500/Case, 1-Serving Bags	¤ 19.00	0.5	false	Discount	2009.0
13	Coffee Filters	500/Case, Fits 10-12 Cup Coffee Maker	¤ 3.00	0.5	false	House	2010.0
14	Napkins	3000/Case, White	¤ 20.00	1.0	false	House	2011.0
15	Stirrers - Plastic	1000/Box	¤ 1.50	0.75	false	Discount	2012.0
16	Stirrers - Wood	1000/Box	¤ 1.25	1.0	false	Discount	2008.0
17	Spoons	500/Box, White Plastic	¤ 15.00	1.0	false	House	2009.0
18	Popcorn - Plain	36/Case, 3.75 Oz Microwave Bags	¤ 8.50	1.0	false	House	2010.0
19	Popcorn - Buttered	36/Case, 3.75 Oz Microwave Bags	¤ 9.50	1.0	false	House	2011.0
20	Soup - Chicken	50 Envelopes	¤ 10.00	1.0	false	Premium	2012.0
21	Soup - Variety Pak	50 Envelopes	¤ 12.00	1.0	false	Premium	2008.0
22	Styrofoam Cups - 10 ounce	1000/Case	¤ 17.00	0.5	false	House	2009.0
23	Styrofoam Cups - 12 ounce	1000/Case	¤ 19.00	0.5	false	House	2010.0
24	Milk - 1 quart	Delivered Daily	¤ 2.00	1.0	true	House	2011.0
25	Milk - 1 pint	Delivered Daily	¤ 1.00	1.0	true	House	2012.0

SalesRepID	LastName	FirstName	Address	City	State	ZipCode	HomePhone	CellPhone	SSN	Gender	BirthDate	HireDate	HighestDegree	CurrentSalary	PreviousSalary	LastRaiseDate	SalesRepPhoto
1	Peter	Sazcick	Green St.	Naples	FL	33276	9541113333	9541113345	111111111	M	5/16/58	1/1/05	Master's Degree	¤ 50,000.00
2	Mast	Keith	10000 Sample Road	Coral Springs	Fl	33071	9541112222	9541112223	222222222	M	4/1/58	1/1/05	Bachelor's Degree	¤ 65,000.00

OrderID	ProductID	Quantity
1	1	1
1	6	2
2	2	2
2	8	1
2	10	1
3	2	2
3	8	2
3	12	1
4	3	1
4	7	1
4	9	2
4	15	1
5	1	3
6	1	2
6	6	2
6	9	2
7	2	3
7	10	2
7	13	2
8	2	1
8	3	1
9	13	2
9	14	1
9	15	1
10	1	1
10	5	1
10	9	2
11	3	1
11	6	2
11	15	1
12	2	2
13	4	2
13	7	1
13	12	1
14	1	1
14	5	1
14	10	1
14	12	1
14	18	2
15	14	1
15	16	1
15	20	2
15	21	2
16	1	2
16	2	2
16	8	2
16	14	1
17	23	1
18	1	2
18	3	2
18	24	1
19	6	2
19	10	1
19	17	1
20	1	1
20	2	1
20	3	1
21	8	1
21	10	1
21	23	1
22	4	3
23	2	2
23	6	1
23	14	1
23	23	1
24	5	1
25	1	3
25	7	2
25	20	2
25	21	2
26	12	1
26	18	4
27	13	1
27	19	2
27	23	1
28	3	1
28	9	2
28	19	1
29	5	1
29	21	1
30	3	2
30	9	1
30	21	3
31	6	2
31	19	2
31	24	1

OrderID	ProductID	Quantity
1	1	1
1	6	2
2	2	2
2	8	1
2	10	1
3	2	2
3	8	2
3	12	1
4	3	1
4	7	1
4	9	2
4	15	1
5	1	3
6	1	2
6	6	2
6	9	2
7	2	3
7	10	2
7	13	2
8	2	1
8	3	1
9	13	2
9	14	1
9	15	1
10	1	1
10	5	1
10	9	2
11	3	1
11	6	2
11	15	1
12	2	2
13	4	2
13	7	1
13	12	1
14	1	1
14	5	1
14	10	1
14	12	1
14	18	2
15	14	1
15	16	1
15	20	2
15	21	2
16	1	2
16	2	2
16	8	2
16	14	1
17	23	1
18	1	2
18	3	2
18	24	1
19	6	2
19	10	1
19	17	1
20	1	1
20	2	1
20	3	1
21	8	1
21	10	1
21	23	1
22	4	3
23	2	2
23	6	1
23	14	1
23	23	1
24	5	1
25	1	3
25	7	2
25	20	2
25	21	2
26	12	1
26	18	4
27	13	1
27	19	2
27	23	1
28	3	1
28	9	2
28	19	1
29	5	1
29	21	1
30	3	2
30	9	1
30	21	3
31	6	2
31	19	2
31	24	1

OrderID	ProductID	Quantity
1	1	1
1	6	2
2	2	2
2	8	1
2	10	1
3	2	2
3	8	2
3	12	1
4	3	1
4	7	1
4	9	2
4	15	1
5	1	3
6	1	2
6	6	2
6	9	2
7	2	3
7	10	2
7	13	2
8	2	1
8	3	1
9	13	2
9	14	1
9	15	1
10	1	1
10	5	1
10	9	2
11	3	1
11	6	2
11	15	1
12	2	2
13	4	2
13	7	1
13	12	1
14	1	1
14	5	1
14	10	1
14	12	1
14	18	2
15	14	1
15	16	1
15	20	2
15	21	2
16	1	2
16	2	2
16	8	2
16	14	1
17	23	1
18	1	2
18	3	2
18	24	1
19	6	2
19	10	1
19	17	1
20	1	1
20	2	1
20	3	1
21	8	1
21	10	1
21	23	1
22	4	3
23	2	2
23	6	1
23	14	1
23	23	1
24	5	1
25	1	3
25	7	2
25	20	2
25	21	2
26	12	1
26	18	4
27	13	1
27	19	2
27	23	1
28	3	1
28	9	2
28	19	1
29	5	1
29	21	1
30	3	2
30	9	1
30	21	3
31	6	2
31	19	2
31	24	1