Covert RAR files to Access
latice1
chapter_2_lab3.rarChapter 2 lab3/Client Query.csv
| Alvarez | Francine | $400.00 | $44.00 | 203 |
| Breeton | Alex | $524.00 | $64.00 | 205 |
| Chalmer | Ben | $520.00 | $0.00 | 203 |
| Ferber | Jane | $420.00 | $72.00 | 207 |
| Gammon | Fred | $560.00 | $50.00 | 205 |
| Hammond | Lois | $675.00 | $125.00 | 203 |
| Heijer | Bill | $240.00 | $48.00 | 203 |
| Klinger | Cynthia | $640.00 | $0.00 | 203 |
| Last | Bill | $780.00 | $420.00 | 205 |
| Manchester | Liz | $348.00 | $40.00 | 207 |
| Preston | Mike | $440.00 | $40.00 | 205 |
| Santoro | Maria | $340.00 | $36.00 | 207 |
| Thomas | Albert | $0.00 | $450.00 | 207 |
| Trent | Jerry | $480.00 | $42.00 | 205 |
| Width | Evelyn | $1040.00 | $340.00 | 207 |
Chapter 2 lab3/lab_3_shopper.accdb
| Client Number | Last Name | First Name | Address | Telephone Number | Amount Paid | Balance | Shopper Number |
|---|---|---|---|---|---|---|---|
| AB10 | Alvarez | Francine | 23 Robbins | 555-4321 | ¤ 400.00 | ¤ 44.00 | 203 |
| BR18 | Breeton | Alex | 345 Levick | 555-6987 | ¤ 524.00 | ¤ 64.00 | 205 |
| CH21 | Chalmer | Ben | 123 Unruh | 555-2345 | ¤ 520.00 | ¤ 0.00 | 203 |
| FE47 | Ferber | Jane | 68 Passmore | 555-3412 | ¤ 420.00 | ¤ 72.00 | 207 |
| GM50 | Gammon | Fred | 98 Magee | 555-8789 | ¤ 560.00 | ¤ 50.00 | 205 |
| HA15 | Hammond | Lois | 346 Magee | 555-1915 | ¤ 675.00 | ¤ 125.00 | 203 |
| HJ05 | Heijer | Bill | 314 Oakley | 555-4365 | ¤ 240.00 | ¤ 48.00 | 203 |
| KL10 | Klinger | Cynthia | 44 Rising Sun | 555-4576 | ¤ 640.00 | ¤ 0.00 | 203 |
| LA75 | Last | Bill | 348 Dade | 555-1234 | ¤ 780.00 | ¤ 420.00 | 205 |
| MA24 | Manchester | Liz | 67 Fanshawe | 555-8787 | ¤ 348.00 | ¤ 40.00 | 207 |
| PR30 | Preston | Mike | 75 Ulhrich | 555-4454 | ¤ 440.00 | ¤ 40.00 | 205 |
| SA23 | Santoro | Maria | 134 Castor | 555-9780 | ¤ 340.00 | ¤ 36.00 | 207 |
| TH41 | Thomas | Albert | 23 Gilham | 555-2897 | ¤ 0.00 | ¤ 450.00 | 207 |
| TR35 | Trent | Jerry | 167 Martin | 555-7667 | ¤ 480.00 | ¤ 42.00 | 205 |
| WI87 | Width | Evelyn | 245 Dade | 555-1987 | ¤ 1,040.00 | ¤ 340.00 | 207 |
| Shopper Number | Last Name | First Name | Hourly Rate |
|---|---|---|---|
| 203 | Kim | Rachel | ¤ 15.00 |
| 205 | Martinez | Alex | ¤ 15.50 |
| 207 | Pretsch | Pat | ¤ 14.00 |
| 209 | Carpenter | Dan | ¤ 13.00 |
SELECT DISTINCTROW *
FROM Client;
SELECT DISTINCTROW *
FROM Shopper;
SELECT DISTINCTROW *
FROM Client;
SELECT Shopper.[Last Name] AS [Shopper_Last Name], Shopper.[First Name] AS [Shopper_First Name], Client.[Client Number], Client.[Last Name] AS [Client_Last Name], Client.[First Name] AS [Client_First Name], Client.Balance
FROM Shopper INNER JOIN Client ON Shopper.[Shopper Number] = Client.[Shopper Number]
ORDER BY Shopper.[Last Name], Client.[Client Number];
SELECT Client.[Last Name], Client.[First Name], Client.[Amount Paid], Client.[Balance], Client.[Shopper Number]
FROM Client
ORDER BY Client.[Last Name];
