Important

I need help in my homewrok I have issue in uploading access files

ID	mSysRowId
1	mGfwr03G2wOuJ4bszzrO4ntFp9V0CM+nTrPvhUCKcK4=-~plyeY2yn2vQWsp1PBkI9GQ==

5

Sophomore

Business Administration Freshman

5

Sophomore

Liberal Studies Freshman

Business Administration Sophomore

Computer Science Freshman 3.2

Liberal Studies Freshman 3.4

Business Administration Sophomore 3.65

Elementary Education Freshman

Liberal Studies Freshman

Computer Science Sophomore

Campbell

Elementary Education Freshman 3.5

Computer Science Sophomore

StudentID	Last Name	First Name	Major	Year of Study	GPA
123450	Sullivan	Diana				Business Administration							Sophomore	3.0
123451	Owen	Audrey				Liberal Studies								Freshman		3.2
123452	McGraw	Adriana			Elementary Education	3.75
123453	Kavanagh	Cornelius		3.4
123454	Ennis	Claudius				Computer Science	2.9
123455	Conway	Edgar		3.5
123456	Connelly	Rosaline		3.65
123457		Campbell	Ross
123458	Blair	Isabella
123459	Bard	Jessica
123460	Abernethy	Robin	3.85
123461	Adair	Margaret	2.75
123462	Bain	Bianca	3.3
123463	Paris
123464	McFadden	Nathaniel	3.15

SELECT DISTINCTROW *
FROM [Transfer Students];

1 E. Main St.

6261

)

55-2190

2

40

3

4

Richwood

5

Richwood 26261

6

Summersville 26651

7

Princeton

												CustomerNumber	Customer_FName	Customer_LName	Address	City	ZIP	Phone					mSysRowId
		1	Patrick	Connelly			6		3			Richwood			2	(30		4		5	1XadGInapk+ZllJVgJtemwtE+HB6cslFPtOrdbvLXgU=-~0tyyOwejJu1x51TxgUT8pw==
Isabel	Rosario	96 Mountain Rd.		Princeton	24		7	(304) 555-1890	FFKezpiigtPCloLRZX2eWyxgk4SFhj1M32mDq8oRjAc=-~Y4wSRh4FRyaGIIwHU8j0/w==
Philip	Arutt	1926 Street Rd.		Summersville		26651	(304) 555-6572	9c6piiSrHGvI9OtVEWUICpH9H7OBvQO8w4RdXtF2GhQ=-~d2H4KN44aXikD5gjnevWGg==
Lisa	Nemphos	241 Harrison Ave.		26261	(304) 555-0714	V91XeUHtAIsqRC9N0AGrAk6JqEpqJLzv6LQ7VmhOaWo=-~Z7Z3ilEF8NqREJIrtrDL1g==
Hector	Melendez	18 Jones Ave.	(304) 555-8206	oNIvVdqPKpF2RXHmUbZJuJuWSoQ94KaCaYX6Rjfn7ck=-~18OumvFOexhqzh9i0WU4tA==
Gilesky	Shaw	45 W. Ridge St.	(304) 555-9917	l8RaVzlPFnSEkVOTZF1psea8ItNT5aQxzWg+nAQoljc=-~ZyscQjj84agUEEdP+zLlFA==
Jennifer	Katzeff	161 Garth Rd.	24740	(304) 555-4015	Pjch85qK5HMdT+spLclUK7FMYnqslFgv5DJYJugBb/w=-~8c7AHo6j7z2bNc7OSD+25g==

mSysRowId

1

ID
kmWjKOKPpA6gVdSOEVdNFvTMyQoY2ZXX+mOHB6bNHwc=-~B2u/fjuG1hBcOSnlbM9DKg==

CustomerNumber

mSysRowId

1

2 7/17/12 RPS23005

3 7/17/12

4 7/17/12

5 7/17/12

6 7/17/12 RPS23006

7 7/17/12 RPS23005

OrderNumber	OrderDate		ProductID	PhotographerID
1000							7/17/12				RPS23005	RZPzYZWIaJD4w/GnTVY/aUXAkWr/nQnL7Hqo8eS+qPA=-~lK6tLDELCDw7N8WTkQJgww==
2000	s8Ca2/bT0NVCphiHenp5FRlnXe6Lm9+PlN3W2Xkzgr4=-~7nhwttFUd794rvCtU6mmJw==
3000			RPS23006	h2o/4aMDminP6y1PvskjvnBUg4UcfoTDe9tVv8y/BmI=-~VkF5RD57J/XYDXdmZIeG6A==
4000		RPS23007	kjQn9yAZtZvZNrZ+BqRd5pRI3C+kb+IvZOymvIOjB5s=-~SpT2U1p6pCQ7kzPhoGDyFQ==
5000		RPS23008	J+/1f8iREstrMP58ae03SNvT5HfIQnjylL2LPfHkK4k=-~Qmep5IH8gfFQEpkmZrux7g==
6000	nekGO9gl6betsH2WSDOiBo3ezrhdmNMU62P4gRlUkYo=-~NiD6fIGTdjxTlOO0qoWHrw==
7000	wNNQoYXq9yrpCA2uiV9I8GlzXG2bSzTyNXrYqDT38kg=-~zkQB9Jt0WS9QfgWelQMqzw==

mSysRowId

RPS23005

RPS23006

RPS23007

RPS23008

EmployeeID	First_Name	Last_Name	Schedule
Daniel	Pegg	VPExQwNHIlFQycfbwvYnLqhlarKbfmJwzz63CxpyeLA=-~D+0P4SJ+2GnM9ixgUO4DdA==
Renee	Harkins	iWiEnqoo9PxuBt/5GsiFBF7DQjpw76YzaY624jqf1i8=-~jtLnZWgPbhtwm1y9d4q6Yg==
Joshua	Scholl	iGped8EGNgxfccbAsSG5FyInaYgEHYj7f778AgWuuNk=-~2CfF8bNI7SfHBjaZ3bf63w==
Jessica	Rodriguez	Q2IW/R0tVOaHEwTj4y1SC4i2s+efa8rhxW9HhBpYtHg=-~A8x5X6k7IKEN57396JVyEw==

ProductID

mSysRowId

¤ 2.99

¤ 2.99

Poster; Two Enhancements

¤ 5.99

¤ 5.99

¤ 5.99

10 X 13

Description	Price
Enhancement1	Black & White			¤ 2.99	Cqd0AF6FuJuLA0dKcQUOWUvWtMX82JVwONtxIE3BI2o=-~ECv7v1QInOPXd1dY1U9gqg==
Enhancement2	Sepia	n1enJxID86gU/3qGZbuHwHpl3kO9uCpnREn0e0v/YGU=-~ZhobZX+im0LuMmm+woc/jw==
Enhancement3	Vignette	1AHBi1ZtSe19rhkJFss3r81lg5+DnrnE+aGlra2KLCM=-~ccV/pZbaqLc158ceH4E21w==
Package1	Four Sheets; Two Enhancements	¤ 25.00	9yOvE8FmcVweiBleyce2pyWrfCZuruupixHr9PRWh00=-~FPVSFd6aFM62wcFQByn7qA==
Package2	Eight Sheets; One	10 X 13	¤ 55.00	i7lQS3N0a4JNjV3US3ijAABxK0Azw+TrpC1GS/n7snI=-~pEkcL8zXQ+ggHrdrDFVoxQ==
PortraitCD	Portrait CD	¤ 59.99	rRteOoKo3SrdPHEPcxAEPB7FV/fO7JvAFATk3SLSKV4=-~fPiM4lZgBJud9ikWxHhBtA==
PortraitSheet1	One 8 X 10				¤ 5.99	COre9ReOdb2a65/tATpa4Ituj4+pEuUcuUOGlwTC/7w=-~wrC6uzhgc3+bctzLCQoL3Q==
PortraitSheet2	Two 5 X 7	V34Q4rhVYpq5RfqK99NjsCQqTBpIrgrO4H8llvyA9Xs=-~gt2aNaMVUU3hY3yF6fqoJw==
PortraitSheet3	Four 3 1/2 X 5	+IRSAIhrzbdobKEL8Q0DZJZk/xLTozHwpyQZ6neVYA8=-~ch6EInLC+jUvnP+DlxcRZw==
PortraitSheet4	Eight Wallets	acRboSNPRU9KqNgGD5JdS3JK7eZCXDRyRBy89X8kl5Y=-~D8jeF7Cc5MeWbxkWK5wMAg==
Poster1	¤ 20.99	7cDxd6joc/Cvgp4yKzvdSpcMG2rwKlFtFwxuZkhuejg=-~3jyBt+1IH/JaGBRaPl3LSw==
Poster2	16 X 20	¤ 25.99	XF+I59eReM1HZZUK9PffqxGEnHM5zgGUYWXA4FnnthI=-~H6jIWDMpXUfIsCHx7ndulw==
Poster3	20 X 24	¤ 30.99	Q0UiYBPF+lYdQZ0ohR6dudkjfYuXOLBJmerWYrEZRV8=-~5ljSzGwCJsCVrd5HhnQuSg==
SittingFee	Sitting Fee	¤ 15.00	yWdg317jCtRHVQsFy85abxLcITe1VDcXS4oL9fDlAsE=-~XLHpYQhiFq19l61fW9njcg==

SELECT [Products].[ProductID]
FROM Products;
SELECT [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [Customer Information].[Address], [Customer Information].[City], [Customer Information].[ZIP], [Customer Information].[Phone], [Order Details].[OrderDate], [Order Details].[ProductID]
FROM [Customer Information] INNER JOIN [Order Details] ON [Customer Information].[CustomerNumber] =[Order Details].[CustomerNumber];
SELECT DISTINCTROW *
FROM Photographers;
SELECT DISTINCTROW *
FROM Products;
SELECT [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Order Details].OrderDate, Sum(Products.Price) AS SumOfPrice
FROM Products INNER JOIN ([Customer Information] INNER JOIN [Order Details] ON [Customer Information].CustomerNumber=[Order Details].CustomerNumber) ON Products.ProductID=[Order Details].ProductID.Value
GROUP BY [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Order Details].OrderDate;
SELECT DISTINCTROW [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[OrderDate], Sum([Products].[Price]) AS SumOfPrice
FROM Products INNER JOIN ([Customer Information] INNER JOIN [SELECT [Order Details].[CustomerNumber], [ProductID_9A868D4953084B219FBC4CBE85135049].[Value], [Order Details].[OrderDate]
FROM [Order Details] LEFT JOIN [f_E6640A865B3446B6B1C7CF874FAD0DF2_TempField*0] AS ProductID_9A868D4953084B219FBC4CBE85135049 ON [Order Details].[ProductID]=[ProductID_9A868D4953084B219FBC4CBE85135049].[_TempField*0]]. AS QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49 ON [Customer Information].[CustomerNumber]=[QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[CustomerNumber]) ON [Products].[ProductID]=[QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[ProductID_9A868D4953084B219FBC4CBE85135049].[Value]
GROUP BY [Customer Information].[Customer_FName], [Customer Information].[Customer_LName], [QESubquery_8E540BB96B3D46C7B4E5DDD89E582B49].[Order Details].[OrderDate];
SELECT [Customer Information].Customer_FName, [Customer Information].Customer_LName, [Customer Information].Address, [Customer Information].City, [Customer Information].ZIP, [Customer Information].Phone, [Order Details].OrderDate, [Order Details].ProductID
FROM [Customer Information] INNER JOIN [Order Details] ON [Customer Information].CustomerNumber = [Order Details].CustomerNumber;

0

) Tableware

/

/09

50.00

=-~b8

iTLNP1/w1WnFJiACOmw==

(1) Tableware (2) Good

Royal Berkshire

TVqIK/waruYL81yfVg==

4

(1) Tableware (2) Good 9/4/09

Royal Berkshire

5

(1) Tableware (2) Good 9/4/09 ¤ 750.00 Royal Berkshire

6

(1) Tableware (2) Good 9/4/09 ¤ 625.00 Royal Berkshire

7

(1) Tableware (2) Good 9/4/09

Royal Berkshire

8

9

(2) Cutlery (3) Satisfactory 9/5/08

Hinkels

10

(2) Cutlery (2) Good 9/5/08

Hinkels

(2) Cutlery (2) Good 9/5/08

Hinkels

(3) Cookware (2) Good 9/1/09 ¤ 100.00 Babylon

(3) Cookware (1) Great 9/1/09 ¤ 550.00 Babylon

(3) Cookware (2) Good 9/1/09 ¤ 100.00 Babylon

(3) Cookware (2) Good 9/1/09

Babylon

																														Asset		ID	Description	Category	Condition	Acquired Date	Purchase Price	Manufacturer	Owner	Retired Date		mSysRowId
2	Tea Cup and Saucer-	5						(	1											(2) Good			9	4		¤	7						Royal Berkshire	DVNee9PQAuTDF1LyiZEZL0ewwwHH9BfXGgitV0aWVd	8	6
3	Coffee Mugs-50				9/4/09		¤ 625.00	Pc8WDx8PfKlj6mY4Tnxwqb+0ArTsQX2A2AGV2ddnBgI=-~1v	10
Dinner Plates-50	¤ 1,000.00	d4j91WRceAzvR0jgc8XL3UaGc9ZyRtpxaSv+euytGHY=-~kUXg8KCX3vPK1wvhm8zpnA==
Salad Bowls-50	7RhFKaj/QUYG5AyJuuYbntJdr8T/DLbIfDx5WTD+ouY=-~PamPYJ0kGVS/NiJUOzKEuw==
Dessert Plates-50	on2aNX7mSOquyrGgLn7fW4YLNtc3a/+SG3WZsiQiUWI=-~XC58kSFuAHfU3rIkvLHgDw==
Bread and Butter Plates-50	¤ 587.50	XJDVdlCz6e4ISwu46rBFsgzESl67CVzaUvfoAguBExo=-~zHFjRqDu0/SK+G6PG/LdkQ==
Five-piece cutlery sets-50				(2) Cutlery		(3) Satisfactory				9/5/08	¤ 1,500.00				Hinkels	mspKyPlIoewc1upDW8U4TxSt0bcYFrfJhlnwmWUnOYI=-~UCz7XQoZjb6NrkO7V5DnWw==
Gourmet 23-piece cutlery set-1		¤ 550.00	K4g+umzsRKu4PZ/rmHndAlkrVHfZvWmv4/yn57Hoj6M=-~nv8/XT43KeXcNCe6Beadow==
Four-piece steak knife set-6	¤ 360.00	HVEtrDpC/jxLDekZUV8my3Gh/yhmIUH962TjVahbpnY=-~uNzg/FtvvA8rUfizvpM/2w==
11	Santoku knife 7 inch-2			¤ 100.00	A31BnEHrjS9gmmVk1p74uhwFwIaPp+tCyJgWlVPSwNo=-~2GK0EolY4DQv2aY0EgKFag==
12	Non-stick ten-piece cookware set-2					(3) Cookware		(1) Great					9/1/09	¤ 800.00					Babylon	5flkuddEha1Imshih2V7gc4kLn5T44kcXNrRRtfNqp0=-~cl1I9sAWuALBKW+vo7isRw==
13	Triple-pack fry pan set-2	rvFvtej2aeMVAzficsbcnme85RvCZ+mZHoqR43NFRLA=-~khdhEX+uHvUnBLCAPmGqQQ==
14	Cast iron French oven collection	Uobf+GgA7QqMmLgcbA43utBvKx7yo2tzlfaOGc9mzu0=-~0KMltM4eMV5vvMua9T6ypw==
15	14-inch stir fry pan-2	+eBzCMVUEp3DlId1qfe0iL3uWrBxQrkG9KVLn5LWh8s=-~WSuoi0XvmslgHwrYIGxSHw==
16	16.5-inch roaster with roasting rack-2	¤ 120.00	0dG8/FgTsr1Ik7e0d8d5bxK9Szf0ZTESACsFw0FdWnA=-~4QYqrA+sNTOW171oHcNeWw==

ID

Address

Company	Last Name	First Name	E-mail	Address	Job Title	Business Phone	Home Phone	Mobile Phone	Fax Number	City	State/Province	ZIP/Postal Code	Country/Region	Web Page	Notes	Attachments

ID mSysRowId
1

pYsfHh9Itcy6zjJCTLHkuSfkulPPmVckkUErqGEa+WI=-~MuPDTOOrWVHYaOOmTq89Bw==

SELECT [Contacts Extended].ID, [Contacts Extended].[Contact Name]
FROM [Contacts Extended]
ORDER BY [Contacts Extended].[Contact Name];
SELECT Assets.*
FROM Assets
WHERE (((Assets.[Retired Date]) Is Null Or (Assets.[Retired Date])>=Date()));

W. Trenton Road

50

19) 555-4

5

7yU8k1

RDjNZc/Pa+QSF5GpVSbPY6689RGpxIY8rk=-~weaa4mHMGGiWBLR7HxcDOw==

2

NC

3

NC

4

Benson NC

nRcpl0JierQ==

5

Four Oaks NC 27524

6

NC

7

Benson NC 27504

8

Four Oaks NC 27524

9

Angier NC 27501

38

10

Benson NC 27504

11

Willow Spring NC 27592

12

Benson NC 27504

Willow Spring NC 27592

Customer	ID	FName	LName	Address	City	State	ZIP	PhoneNumber				mSysRowId
		1	Albert	Martin			8		2		5					Benson													NC	2		7		4	(		9		10	A		6		3
Jason	Rawlings	72 Ridge Avenue			Willow Spring			27592	(919) 555-0086	bEQDVbHmc6cdPxUCFK6zMEok9QRzocxCq/SRSwQw/NE=-~DrVFdjdCxJsBtYp2M2eyVQ==
Theresa	Bond	23 E. Happ Road			Four Oaks			27524	(919) 555-2418	IZ4G/NbH1pxEwQmayBk1WyKWOV2GkKOtjGZlCk108cg=-~/39LtNJxI3ph+pI6PXUPwQ==
Patrina	Greene	1424 Valley Road				27504	(919) 555-0276	OifCiDzd2vhWLGZ5ID7avlxt9Tdjuf2UbvG1iJd4ovQ=-~9XogOWWgC		12
Karin	Harris	40 Grove Street	(919) 555-9341	r/yGkdCDjWK6n527Bt3vd9A0nQP48IRzebCfXFN4FDE=-~fe50SNg0+ws+uJFMcHwL6A==
Edward	Duvall	861 Edgebrook Road		Angier		27501	(919) 555-5630	GAeCeBXGPXhdZwVoAEObfypHNB5HiNDRt96A5J5y1AE=-~0nlbkVFm4VZSd/g0Tm8/Tw==
Stacey	Scott	94 N. Bridge Street	(919) 555-9775	lpDHiSDJ/8oBato8ubiHBIpk36XIpK+E9PSG6xSWq5U=-~hXGstMfCe40sKGQxtCMbrQ==
Brittney	Baker	18 E. Oak Lane	(919) 555-3421	5jjRaGzDQcDgokpww0B+d1xoF69nH5zIb6jBWT/uIJY=-~4gVaMIiVHtmfHKyYT4H68g==
Jonathan	Barbash	497 Street Road	(919) 555-		11	eMkht3Bnngo0VGQxzRJLXYcqjS2tG2IdZcAOxJiOetk=-~LYfPbnExh0183YGddDBCcQ==
Marni	Walton	527 S. 88th Street	(919) 555-8410	T2KDnNxte8yq5tTFbfG0huae67vdc9OT3UB2zdKwc7U=-~czNb5hU5Nf5r79WzEs6S0g==
Debra	Schmitt	20 Ridge Avenue	(919) 555-9037	THV3d1zLtfiXbgNuqgAg/fTVKc0V/tysXmRBIu1ZrfU=-~YJQfsoq1j4sjhuytzi77EQ==
Justin	Hill	629 N. 17th Street	(919) 555-2501	AI76aSNgslkit7lo8q3TvGdRor9UEh7U08/nBSzcnGc=-~OIGBKN6E3uoYDHX1pZivsQ==
	13	Natalie	Doyle	498 Lorraine Avenue	(919) 555-1876	Tz8kDGY0DHS8UUtT11IlvNzc68AQ/9AzG7COkP9qv8s=-~mFG5/QLXa6U/YGZq41AUqg==

mSysRowId

Toyota

2009

Ford

Toyota

¤ 21,995.00

2008

Chevrolet

2008

Chevrolet

2004

BMW

2006 ¤ 20,995.00

Honda

2006

	CarID	Make	Model	MYear	AskingPrice
	BCS-002461			Chevrolet	Impala		2009			¤ 20,995.00	EfTQ6bDdvmJvLzoennCB8YxMk1CRQbbPtdk+RnuJB3M=-~o48oz7cYVz5b0D4W86kARA==
	BCS-002462			Toyota	Highlander			2006	¤ 19,998.00	BfkVPxO4ke1EI9HBws0IPtvJ1vjFxfasXitK2B9W9Bc=-~cgRQ19wsJXJBI+MjEcZ0lQ==
	BCS-002463		Ford	Crown Victoria	1999	¤ 5,800.00	xLdKU8oSpccZGi+W6nBmaSlaBN3MbypbzCu11XI1/xc=-~R2oBwhkoQDhZuklfjoKfpQ==
	BCS-002464	Corolla	¤ 17,966.00	rmUDf0+FZMwn9H8JAdJPkckSi3qKzhqiqA70EMBCtl8=-~FE/TXYYueub5sQlT8/KU3A==
	BCS-002465	F150	2007		¤ 21,995.00	iohGj3W7TxHdq/LrZx+91UT9lYlrhU4N0C/QFvgPg0Q=-~sulCRRuS36N+IGH2HWr54A==
	BCS-002466		BMW	645Ci		2004	¤ 36,982.00	e5/XzfhxgLtgePhFZlmqoghHUGBg9YwJSPZipt9fF3w=-~/i/N2ovH4selwt+ceRR3gw==
	BCS-002467	RAV4			2008	+rMlV8mSD1YIXQkcXSKPM4qok6fNgoXGjJMe3aw1/Us=-~xfdZegsslDxzndQT1Edd5A==
	BCS-002468	Nissan	Altima	¤ 19,695.00	7J8ppE4dqb6/4I/IdhQVtfKpl/c71ljzNdMUHH83pBs=-~XISM8tY3Ft9+h4arLGKYNw==
	BCS-002469	TrailBlazer	2005		¤ 12,995.00	WfB/Iery4kUD6KOdx3LF6EzKis4xvJz/zsmigsFaorY=-~J5CIliQR63pkeMrE6YGPnA==
	BCS-002470		Honda	Civic	¤ 16,995.00	fHVpJfzVICIf48Xyw6kpJVO9nWVwPz4EA8WjY9ref3g=-~nRlxDa9AGnMMLl88RLV5dg==
	BCS-002471	Cavalier	¤ 6,999.00	H/y70eBcY3q44Z4pzmKn37pM6D8AGZgbiB7dNfssSss=-~jR9Af7trxk7/+jIE2tvqNA==
	BCS-002472	325xi	b5CKFAifoOtMYjZPFcIzzS/9xCNRmaTRKx10u7iVuz0=-~3Fj2sEXSPIP8wLU3Q+xuPA==
	BCS-002473	Odyssey	¤ 22,995.00	iL8QVgSj09fZT2TbsKe+SrCyJYJT2OwTrsvmjVrqWpc=-~m7Vppciy6TSBROzKhB82rA==

ID mSysRowId
1

kX069lwmvVdixxkrDTDaK4lmZhuXvXMbkDkrerXF3Rg=-~n9yXfyFGer5+GcwLzcvrKA==

CarID

mSysRowId

BCS-002461

8

BCS-002462

Perez 11

BCS-002463

10

BCS-002464

Perez 2

BCS-002465

6

BCS-002466

Kaffee 12

BCS-002467

Watkins 4 ¤ 20,995.00

BCS-002468

Watkins 3 ¤ 19,500.00

BCS-002469

Perez 5 ¤ 12,995.00

BCS-002470

Watkins 7

BCS-002471

Kaffee 1

BCS-002472 3/15/11 Watkins 9

BCS-002473 3/19/11 Kaffee 13

SaleDate	Agent_LName	CustomerID	SalePrice
	3/15/11				Perez	¤ 19,000.00	DrxK12gVHnJSoZpB4ANnUut6fZ2S2VkCfAQcI/vnjko=-~lDrY5VUrRisCCDi8sp41dw==
3/18/11		¤ 19,500.00	1wHzg/IlxzazLMU26rg7IL4PPTiMORUQr+zk82vj3Bc=-~HsjxQ+o5JhqN+DtVheau1A==
3/16/11					Watkins	¤ 5,000.00	4Jl8ix+k15FMKn8/rreBy6swZrBuSEVMOlBactf8EW8=-~i6wz9ZdNwAg9A8IefwpM2g==
3/9/11	¤ 17,325.00	YESuZKEFgQYXQBPO/hiPLDBc8fTqimSSZG70ylr3/EQ=-~/5ouyNgO7wvg1liUTcJdlQ==
3/13/11				Kaffee	¤ 20,900.00	a/YIPkiuwv2OWLhBK6saXn1v1vj0oDnW5b++5TvtBXM=-~ZgP5bsXPVpMTEbSkh8V9vQ==
	3/19/11	¤ 36,000.00	fpVOTT98s/s/ScldjuIE5bXMpbOglAp8UTZAkgDKRio=-~rFdS+xNDa+s6g5ASKofLcA==
3/11/11	Zxq2JWoPj0JwiF3OcRqQB1HecQC5PQdIDH0OfoDWvHg=-~N4aymqvOV1mRzD6UB90/+Q==
3/10/11	doGK4tQ2FVkJvGyPHkolHkqNH6SEkcf7jXNVF2xoixI=-~cYNiWFO0cCj82GfFl7QUUw==
3/12/11	MvISUQaA8k68AWqsrT8DvapkBFXZ66MbYLznNNtfaJY=-~KsRnFnYM39m5loHNMoiPNg==
3/14/11	¤ 16,500.00	qU3G2HK6yvsrxF8ZPHWMJGs+i6hZfEFtRRESCnXWkQE=-~f68BXdh4S68lGx+ONZE3sg==
3/6/11	¤ 6,300.00	vCEapnT+xregwlzZvq8XwPv6krzE0mbnGLCcyvtkaU0=-~2xRz5dMb2YrMEehUsXP2sg==
¤ 20,000.00	cFPJFpYyi2N5V/BBp1j0259iiQ9jkiAAQHY33GlckOo=-~yE5utJDi3ke76LNlN6cJqA==
¤ 21,000.00	MPtGnJxQVAAH3xyYDHHz3s5A70PsZ1L8WDjZV2LQQR4=-~Oa1w6NXJbzQVk1jWH0FCOw==

SELECT [Sales Data].Agent_LName, [Sales Data].SalePrice, [SalePrice]*0.1 AS Commission, IIf([SalePrice]>=20000,”250″,”0″) AS Bonus, Sum([SalePrice]+[Commission]+[Bonus]) AS Total
FROM [Sales Data]
GROUP BY [Sales Data].Agent_LName, [Sales Data].SalePrice, [SalePrice]*0.1, IIf([SalePrice]>=20000,”250″,”0″)
ORDER BY [Sales Data].Agent_LName;
SELECT [Customer Data].FName, [Customer Data].LName, [Sales Data].SalePrice, [SalePrice]*0.08+[SalePrice] AS TotalCost, Pmt(0.04,60,[TotalCost],0,0) AS MonthlyPayment, DatePart(“w”,[SalesData]![SalesData],1,1) AS WeekDayofSale
FROM [Customer Data] INNER JOIN [Sales Data] ON [Customer Data].CustomerID = [Sales Data].CustomerID;