Access
latice1
lab_3_shopper.accdb| Last Name | First Name | Address | Telephone Number | Amount Paid | Balance | Shopper Number | Client Number |
|---|---|---|---|---|---|---|---|
| Alvarez | Francine | 23 Robbins | 555-4321 | ¤ 400.00 | ¤ 44.00 | 203 | AB10 |
| Breeton | Alex | 345 Levick | 555-6987 | ¤ 524.00 | ¤ 64.00 | 205 | BR18 |
| Ferber | Jane | 68 Passmore | 555-3412 | ¤ 420.00 | ¤ 72.00 | 207 | FE47 |
| Gammon | Fred | 98 Magee | 555-8789 | ¤ 560.00 | ¤ 50.00 | 205 | GM50 |
| Heijer | Bill | 314 Oakley | 555-4365 | ¤ 240.00 | ¤ 48.00 | 203 | HJ05 |
| Klinger | Cynthia | 44 Rising Sun | 555-4576 | ¤ 640.00 | ¤ 0.00 | 203 | KL10 |
| Manchester | Liz | 67 Fanshawe | 555-8787 | ¤ 348.00 | ¤ 40.00 | 207 | MA24 |
| Preston | Mike | 75 Ulhrich | 555-4454 | ¤ 440.00 | ¤ 40.00 | 205 | PR30 |
| Santoro | Maria | 134 Castor | 555-9780 | ¤ 340.00 | ¤ 36.00 | 207 | SA23 |
| Trent | Jerry | 167 Martin | 555-7667 | ¤ 480.00 | ¤ 42.00 | 205 | TR35 |
| Chalmer | Ben | 123 Unruh | 555-2345 | ¤ 520.00 | ¤ 0.00 | 203 | CH21 |
| Last | Bill | 348 Dade | 555-1234 | ¤ 780.00 | ¤ 420.00 | 205 | LA75 |
| Width | Evelyn | 245 Dade | 555-1987 | ¤ 1,040.00 | ¤ 340.00 | 207 | WI87 |
| Thomas | Albert | 23 Gilham | 555-2897 | ¤ 0.00 | ¤ 450.00 | 207 | TH41 |
| Hammond | Lois | 346 Magee | 555-1915 | ¤ 675.00 | ¤ 125.00 | 203 | HA15 |
| 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;
