USA: +1(669)289-8683
USA: +1(669)289-8683

Important

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

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
ID mSysRowId
1 mGfwr03G2wOuJ4bszzrO4ntFp9V0CM+nTrPvhUCKcK4=-~plyeY2yn2vQWsp1PBkI9GQ==

5

Sophomore

Business Administration Freshman

5

Sophomore

Liberal Studies Freshman

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

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;

Still stressed with your coursework?
Get quality coursework help from an expert!
Order now