Access Homewrok

hw2.accdb

ID	mSysRowId
1	cLGPFd1F+jvYwhjoT0wRNGQJAWtHCg28FfDjcJRCDv4=-~zN88OAgAg4Gq1Q+MkobFFg==

CustomerID	LastName	FirstName	Address	City	State	Zip	CustomerName
1	Marsden	Michael	1002 River Road	Potomac	MD	20854	Marsden, Michael
2	Bryant	Cynthia	304 Obispo Canyon	Arroyo Grande	CA	93420	Bryant, Cynthia
3	Peters	John	56 Lake Drive	Blue Lake	CA	95525	Peters, John
4	Nguyen	Jessica	4003 Ridge Road	Dallas	TX	75217	Nguyen, Jessica
5	Richardson	Greg	1030 Presidio Road	Albuquerque	NM	87114	Richardson, Greg
6	Branson	Jenny	3223 El Grande Ln	La Mesa	CA	92010	Branson, Jenny
7	Trumbull	Sara	544 E. Westerly St	Ann Arbor	MI	48104	Trumbull, Sara
8	Ford	James	6127 Fender Dr	Cranbury	NJ	07815	Ford, James
9	Griffin	Elaine	134 Desert Ln	San Luis	AZ	85350	Griffin, Elaine
10	Preston	Harry	455 Fredonia Ave	Herkimer	NY	15253	Preston, Harry
11	Thomas	Erin	9214 Cardinal Ln	Fairfax	VA	23020	Thomas, Erin
12	Dixon	Jack	1022 Century Rd	Blanchard	MO	65898	Dixon, Jack
13	Montaigne	Cheryl	713 Diablo St	Sandiston	OH	44301	Montaigne, Cheryl
14	Mason	Mark	104 Treasure Ln	Brookline	MA	02445	Mason, Mark
15	George	Misty	2575 Purdy St	Fanwood	NJ	07023	George, Misty

ProductID	ProductDescription	Category	QuantityInStock	Price	Size	Color
1	Designer Jeans	Pants	40	¤ 53.99	6	Indigo
2	Designer Jeans	Pants	35	¤ 53.99	8	Indigo
3	Designer Jeans	Pants	50	¤ 53.99	10	Indigo
4	Designer Jeans	Pants	30	¤ 53.99	12	Indigo
5	Sweatpants	Pants	20	¤ 15.00	S	Black
6	Sweatpants	Pants	40	¤ 15.00	M	Black
7	Sweatpants	Pants	50	¤ 15.00	L	Black
8	LS Sweatshirts	Tops	20	¤ 24.99	S	Indigo
9	LS Sweatshirts	Tops	17	¤ 24.99	S	Red
10	LS Sweatshirts	Tops	16	¤ 24.99	S	Silver
11	LS Sweatshirts	Tops	30	¤ 24.99	M	Indigo
12	LS Sweatshirts	Tops	15	¤ 24.99	M	Red
13	LS Sweatshirts	Tops	18	¤ 24.99	M	Silver
14	LS Sweatshirts	Tops	30	¤ 24.99	L	Indigo
15	LS Sweatshirts	Tops	15	¤ 24.99	L	Red
16	LS Sweatshirts	Tops	18	¤ 24.99	L	Silver
17	LS Sweatshirts	Tops	32	¤ 24.99	XL	Indigo
18	LS Sweatshirts	Tops	17	¤ 24.99	XL	Red
19	LS Sweatshirts	Tops	18	¤ 24.99	XL	Silver
20	Tshirts	Tops	50	¤ 15.99	S	Indigo
21	Tshirts	Tops	24	¤ 15.99	S	Red
22	Tshirts	Tops	33	¤ 15.99	S	Silver
23	Tshirts	Tops	60	¤ 15.99	M	Indigo
24	Tshirts	Tops	54	¤ 15.99	M	Red
25	Tshirts	Tops	57	¤ 15.99	M	Silver
26	Tshirts	Tops	30	¤ 15.99	L	Indigo
27	Tshirts	Tops	40	¤ 15.99	L	Red
28	Tshirts	Tops	20	¤ 15.99	L	Silver
29	Tshirts	Tops	15	¤ 15.99	XL	Indigo
30	Tshirts	Tops	30	¤ 15.99	XL	Red
31	Tshirts	Tops	10	¤ 15.99	XL	Silver
32	Tank tops	Tops	50	¤ 11.99	S	Red
33	Tank tops	Tops	50	¤ 11.99	S	Indigo
34	Tank tops	Tops	50	¤ 11.99	S	Silver
35	Tank tops	Tops	50	¤ 11.99	M	Red
36	Tank tops	Tops	25	¤ 11.99	M	Indigo
37	Tank tops	Tops	94	¤ 11.99	M	Silver
38	Tank tops	Tops	80	¤ 11.99	L	Red
39	Tank tops	Tops	40	¤ 11.99	L	Indigo
40	Tank tops	Tops	30	¤ 11.99	XL	Red
41	Tank tops	Tops	104	¤ 11.99	XL	Indigo

PurchaseID	PurchaseLine	ProductID	Quantity
1	1	8	1
1	2	9	2
2	1	5	1
3	1	20	2
4	1	32	1
4	2	15	1
5	1	4	1
6	1	37	1
6	2	40	1
6	3	34	1
7	1	15	1
7	2	6	1
8	1	22	1
8	2	14	1
8	3	4	1
9	1	5	2
9	2	4	2
9	3	27	1
9	4	30	1
10	1	2	1
10	2	6	1
10	3	15	1
11	1	40	1
11	2	41	2
12	1	21	1
12	2	18	1
12	3	10	1
13	1	34	2
13	2	36	1
13	3	39	1
14	1	5	1
14	2	19	1
14	3	36	2
14	4	40	2
15	1	10	2
15	2	7	2
15	3	2	2
16	1	27	1
17	1	3	1
17	2	10	1
18	1	32	1
18	2	33	1
18	3	38	1

PurchaseID	PurchaseLine	ProductID	Quantity
1	1	8	1
1	2	9	2
2	1	5	1
3	1	20	2
4	1	32	1
4	2	15	1
5	1	4	1
6	1	37	1
6	2	40	1
6	3	34	1
7	1	15	1
7	2	6	1
8	1	22	1
8	2	14	1
8	3	4	1
9	1	5	2
9	2	4	2
9	3	27	1
9	4	30	1
10	1	2	1
10	2	6	1
10	3	15	1
11	1	40	1
11	2	41	2
12	1	21	1
12	2	18	1
12	3	10	1
13	1	34	2
13	2	36	1
13	3	39	1
14	1	5	1
14	2	19	1
14	3	36	2
14	4	40	2
15	1	10	2
15	2	7	2
15	3	2	2
16	1	27	1
17	1	3	1
17	2	10	1
18	1	32	1
18	2	33	1
18	3	38	1

PurchaseID	PurchaseLine	ProductID	Quantity
1	1	8	1
1	2	9	2
2	1	5	1
3	1	20	2
4	1	32	1
4	2	15	1
5	1	4	1
6	1	37	1
6	2	40	1
6	3	34	1
7	1	15	1
7	2	6	1
8	1	22	1
8	2	14	1
8	3	4	1
9	1	5	2
9	2	4	2
9	3	27	1
9	4	30	1
10	1	2	1
10	2	6	1
10	3	15	1
11	1	40	1
11	2	41	2
12	1	21	1
12	2	18	1
12	3	10	1
13	1	34	2
13	2	36	1
13	3	39	1
14	1	5	1
14	2	19	1
14	3	36	2
14	4	40	2
15	1	10	2
15	2	7	2
15	3	2	2
16	1	27	1
17	1	3	1
17	2	10	1
18	1	32	1
18	2	33	1
18	3	38	1

PurchaseID	PurchaseLine	ProductID	Quantity
1	1	8	1
1	2	9	2
2	1	5	1
3	1	20	2
4	1	32	1
4	2	15	1
5	1	4	1
6	1	37	1
6	2	40	1
6	3	34	1
7	1	15	1
7	2	6	1
8	1	22	1
8	2	14	1
8	3	4	1
9	1	5	2
9	2	4	2
9	3	27	1
9	4	30	1
10	1	2	1
10	2	6	1
10	3	15	1
11	1	40	1
11	2	41	2
12	1	21	1
12	2	18	1
12	3	10	1
13	1	34	2
13	2	36	1
13	3	39	1
14	1	5	1
14	2	19	1
14	3	36	2
14	4	40	2
15	1	10	2
15	2	7	2
15	3	2	2
16	1	27	1
17	1	3	1
17	2	10	1
18	1	32	1
18	2	33	1
18	3	38	1