Exp19_Access_Ch05_CapAssessment_Paterson_Credit_Union
lacey.xyY
Blake_Exp19_Access_Ch05_CapAssessment_Paterson_Credit_Union.accdb| CustomerID | FirstName | LastName | Address | City | State | ZipCode | PhoneNumber | AccountType | mSysRowId |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Virginia | Stewart | 7245 NW 8 Street | Minneapolis | MN | 55346 | 6128941511 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 2 | Gina | Mullins | 5660 NW 175 Terrace | Baltimore | MD | 21224 | 4107530345 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 3 | Omar | Barton | 10000 Sample Road | Coral Springs | FL | 33073 | 3054445555 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 4 | Melissa | Lynch | 7500 Reno Road | Houston | TX | 77090 | 7134273104 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 5 | Aaron | Figueroa | 3456 Main Highway | Denver | CO | 80228 | 3035556666 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 6 | Shannon | Abbott | 2-2 Murray Street | Chapel Hill | NC | 27515 | 9199427654 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 7 | Morris | Cook | 7075423411 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== | ||||
| 8 | Krista | Williams | 9043745660 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== | ||||
| 9 | Jessie | Richards | 5070 Battle Road | Decatur | GA | 30034 | 3013456556 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 10 | Jesus | Sutton | 777 NW 67 Avenue | Fort Lee | NJ | 07624 | 2016643211 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 11 | Roberta | Harmon | 409 Cook Road | Stoneboro | Pa | 16137 | 7245551212 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 15 | Joyce | Byrd | 17 Snow Goose Place | Altenburg | MO | 63732 | 9692598500 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 16 | Arnold | Porter | 1085 Alana Drive | Colorado City | AZ | 86021 | 9509375705 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 17 | Esther | Moreno | 858 Toadstool Road | Mayfield | UT | 84643 | 9595997109 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 18 | Alan | Adkins | 3512243437 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== | ||||
| 19 | Perry | Sanchez | 2028 Prentice Drive | Clifton | NJ | 07012 | 4249352241 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 20 | Nicholas | Fowler | 2087 Ondola Lane | Dallas | SD | 57529 | 8337024885 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 21 | Yvonne | Tucker | 1674 Casper Street | Van Buren | AR | 72956 | 9596058273 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 22 | Nadine | Christensen | 539 July Creek Street | Browntown | WI | 53522 | 6006664583 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 23 | Garry | Gross | 8579824012 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== | ||||
| 24 | Ruben | Rodgers | 2334 Imperial Circle | Hollansburg | OH | 45332 | 9987362069 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 25 | Joel | Brady | 954 Kidron Way | Star | TX | 76880 | 8223268280 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 26 | Courtney | Santos | 1018 Eide Terrace | Hiram | MO | 63947 | 9768057256 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 27 | Milton | Page | 1197 Cyclone Terrace | Cloverdale | IN | 46120 | 9504711359 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 28 | Rufus | Gibbs | 1403 Maytag Lane | Saint Regis | MT | 59866 | 2246105693 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 29 | Heather | Fuller | 900 Midland Circle | Lexington | OK | 73051 | 5552135251 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 30 | Charlie | Quinn | 1513 Valarian Boulevard | Nashua | NH | 03063 | 3002422114 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 31 | Linda | Obrien | 9768493226 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== | ||||
| 32 | George | Stevenson | 126 Allison Terrace | Sanger | CA | 93657 | 6006531035 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 33 | Johanna | Stephens | 1351 Stonebridge Circle | Danforth | IL | 60930 | 8304946646 | Gold | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 34 | Kate | Simmons | 1708 Stemp Court | Crab Orchard | NE | 68332 | 7115293270 | Silver | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| 35 | Neil | Warren | 1552 Sportsman Way | Washington | DC | 20421 | 9596469432 | Platinum | ONJcDv/Kpqj5WQS8hIg7l3RXaFLHNgT6tH9j/6eEa+Q=-~VkFk/QB+Yl7N7EB/R2gMXw== |
| LoanID | Date | Amount | InterestRate | Term | Type | CustomerID | Adjustable | mSysRowId |
|---|---|---|---|---|---|---|---|---|
| 1 | 2019-01-15 | ¤ 473,500.00 | 6.07 | 15 | M | 4 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 2 | 2019-01-23 | ¤ 36,500.00 | 7.07 | 5 | c | 4 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 3 | 2019-01-25 | ¤ 11,500.00 | 5.37 | 3 | C | 5 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 4 | 2019-01-31 | ¤ 13,500.00 | 9.63 | 10 | O | 4 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 5 | 2019-02-08 | ¤ 523,500.00 | 6.37 | 30 | M | 6 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 6 | 2019-02-12 | ¤ 12,000.00 | 7.63 | 5 | O | 7 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 7 | 2019-02-15 | ¤ 36,500.00 | 6.37 | 5 | O | 8 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 8 | 2019-02-20 | ¤ 248,500.00 | 8.93 | 30 | M | 8 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 9 | 2019-02-21 | ¤ 6,500.00 | 10.13 | 3 | O | 8 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 10 | 2019-02-28 | ¤ 198,500.00 | 6.87 | 15 | M | 1 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 11 | 2019-03-01 | ¤ 26,500.00 | 10.13 | 3 | C | 2 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 12 | 2019-03-01 | ¤ 21,500.00 | 9.63 | 5 | O | 5 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 13 | 2019-03-03 | ¤ 57,500.00 | 7.63 | 5 | C | 9 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 14 | 2019-03-10 | ¤ 127,500.00 | 8.63 | 15 | m | 10 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 15 | 2019-03-11 | ¤ 198,500.00 | 7.12 | 15 | m | 3 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 16 | 2019-03-21 | ¤ 148,500.00 | 7.63 | 15 | M | 1 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 17 | 2019-03-22 | ¤ 98,500.00 | 6.87 | 30 | M | 1 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 18 | 2019-03-31 | ¤ 16,500.00 | 6.37 | 3 | o | 3 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 19 | 2019-04-01 | ¤ 11,500.00 | 8.13 | 5 | C | 2 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 20 | 2019-04-15 | ¤ 26,500.00 | 8.63 | 4 | c | 3 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 21 | 2019-04-18 | ¤ 42,500.00 | 10.03 | 4 | C | 8 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 22 | 2019-04-22 | ¤ 348,500.00 | 7.63 | 15 | m | 10 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 23 | 2019-05-01 | ¤ 148,500.00 | 5.87 | 15 | M | 3 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 24 | 2019-05-03 | ¤ 348,500.00 | 8.33 | 30 | M | 4 | true | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| 25 | 2019-05-08 | ¤ 273,500.00 | 9.33 | 15 | M | 7 | false | LMTqCExfiiSuPfZkrv9W1coLy19RAfH1ByqxKWS2Eu4=-~pLlmwhXL+E6WTnl32DGkOg== |
| Type | LoanName | mSysRowId |
|---|---|---|
| C | Car | WnYo9+ccbav1Jn96YQRI44800jjn6nl+0D9X8cjBY3o=-~8E5GTIwbn8bGN7tM4dC8Kg== |
| M | Mortgage | WnYo9+ccbav1Jn96YQRI44800jjn6nl+0D9X8cjBY3o=-~8E5GTIwbn8bGN7tM4dC8Kg== |
| O | Personal | WnYo9+ccbav1Jn96YQRI44800jjn6nl+0D9X8cjBY3o=-~8E5GTIwbn8bGN7tM4dC8Kg== |
| ID | mSysRowId |
|---|---|
| 1 | j4BFTkfoezSTW0E4Ec3tFCGJ25FWK6wDTYhKaoOfBko=-~8UBgHBNs3VzJUPSiI+B/0g== |
| PaymentID | LoanID | PaymentDate | AmountReceived | mSysRowId |
|---|---|---|---|---|
| 1 | 1 | 2019-02-15 | ¤ 4,317.92 | |
| 2 | 2 | 2019-02-15 | ¤ 621.35 | |
| 3 | 3 | 2019-02-25 | ¤ 226.96 | |
| 4 | 4 | 2019-02-28 | ¤ 80.28 | |
| 5 | 5 | 2019-03-08 | ¤ 3,393.36 | |
| 6 | 6 | 2019-03-12 | ¤ 135.40 | |
| 7 | 1 | 2019-03-15 | ¤ 4,317.92 | |
| 8 | 2 | 2019-03-15 | ¤ 621.35 | |
| 9 | 7 | 2019-03-15 | ¤ 609.82 | |
| 10 | 8 | 2019-03-20 | ¤ 2,050.69 | |
| 11 | 9 | 2019-03-21 | ¤ 86.34 | |
| 12 | 3 | 2019-03-25 | ¤ 226.96 | |
| 13 | 10 | 2019-03-28 | ¤ 1,872.66 | |
| 14 | 4 | 2019-03-31 | ¤ 80.28 | |
| 15 | 11 | 2019-04-01 | ¤ 731.68 | |
| 16 | 12 | 2019-04-01 | ¤ 345.04 | |
| 17 | 5 | 2019-04-08 | ¤ 3,393.36 | |
| 18 | 14 | 2019-04-10 | ¤ 1,195.31 | |
| 19 | 15 | 2019-04-11 | ¤ 1,900.73 | |
| 20 | 6 | 2019-04-12 | ¤ 135.40 | |
| 21 | 1 | 2019-04-15 | ¤ 4,317.92 | |
| 22 | 2 | 2019-04-15 | ¤ 621.35 | |
| 23 | 7 | 2019-04-15 | ¤ 609.82 | |
| 24 | 8 | 2019-04-20 | ¤ 2,050.69 | |
| 25 | 9 | 2019-04-21 | ¤ 86.34 | |
| 26 | 16 | 2019-04-21 | ¤ 1,315.52 | |
| 27 | 17 | 2019-04-22 | ¤ 590.30 | |
| 28 | 3 | 2019-04-25 | ¤ 226.96 | |
| 29 | 10 | 2019-04-28 | ¤ 1,872.66 | |
| 30 | 4 | 2019-04-30 | ¤ 80.28 | |
| 31 | 18 | 2019-04-30 | ¤ 384.74 | |
| 32 | 11 | 2019-05-01 | ¤ 731.68 | |
| 33 | 12 | 2019-05-01 | ¤ 345.04 | |
| 34 | 19 | 2019-05-01 | ¤ 127.76 | |
| 35 | 5 | 2019-05-08 | ¤ 3,393.36 | |
| 36 | 14 | 2019-05-10 | ¤ 1,195.31 | |
| 37 | 15 | 2019-05-11 | ¤ 1,900.73 | |
| 38 | 6 | 2019-05-12 | ¤ 135.40 | |
| 39 | 1 | 2019-05-15 | ¤ 4,317.92 | |
| 40 | 2 | 2019-05-15 | ¤ 621.35 | |
| 41 | 7 | 2019-05-15 | ¤ 609.82 | |
| 42 | 20 | 2019-05-15 | ¤ 541.21 | |
| 43 | 21 | 2019-05-18 | ¤ 962.90 | |
| 44 | 8 | 2019-05-20 | ¤ 2,050.69 | |
| 45 | 9 | 2019-05-21 | ¤ 86.34 | |
| 46 | 16 | 2019-05-21 | ¤ 1,315.52 | |
| 47 | 17 | 2019-05-22 | ¤ 590.30 | |
| 48 | 22 | 2019-05-22 | ¤ 3,319.54 | |
| 49 | 3 | 2019-05-25 | ¤ 226.96 | |
| 50 | 10 | 2019-05-28 | ¤ 1,872.66 | |
| 51 | 4 | 2019-05-30 | ¤ 80.28 | |
| 52 | 18 | 2019-05-30 | ¤ 384.74 | |
| 53 | 11 | 2019-06-01 | ¤ 731.68 | |
| 54 | 12 | 2019-06-01 | ¤ 345.04 | |
| 55 | 19 | 2019-06-01 | ¤ 127.76 | |
| 56 | 23 | 2019-06-01 | ¤ 1,190.79 | |
| 57 | 24 | 2019-06-03 | ¤ 2,692.14 | |
| 58 | 5 | 2019-06-08 | ¤ 3,393.36 | |
| 59 | 25 | 2019-06-08 | ¤ 2,897.05 | |
| 60 | 14 | 2019-06-10 | ¤ 1,195.31 | |
| 61 | 15 | 2019-06-11 | ¤ 1,900.73 | |
| 62 | 6 | 2019-06-12 | ¤ 135.40 | |
| 63 | 1 | 2019-06-15 | ¤ 4,317.92 | |
| 64 | 2 | 2019-06-15 | ¤ 621.35 | |
| 65 | 7 | 2019-06-15 | ¤ 609.82 | |
| 66 | 20 | 2019-06-15 | ¤ 541.21 | |
| 67 | 21 | 2019-06-18 | ¤ 962.90 | |
| 68 | 8 | 2019-06-20 | ¤ 2,050.69 | |
| 69 | 9 | 2019-06-21 | ¤ 86.34 | |
| 70 | 16 | 2019-06-21 | ¤ 1,315.52 | |
| 71 | 17 | 2019-06-22 | ¤ 590.30 | |
| 72 | 22 | 2019-06-22 | ¤ 3,319.54 | |
| 73 | 3 | 2019-06-25 | ¤ 226.96 | |
| 74 | 10 | 2019-06-28 | ¤ 1,872.66 | |
| 75 | 4 | 2019-06-30 | ¤ 80.28 | |
| 76 | 18 | 2019-06-30 | ¤ 384.74 |
SELECT LoanTypes.LoanName, Loans.Date, Loans.Amount, Loans.Term, Loans.Adjustable
FROM LoanTypes INNER JOIN Loans ON LoanTypes.Type = Loans.Type;
SELECT Loans.LoanID, Loans.Date, Loans.Amount, Loans.InterestRate, Loans.Term, Loans.Type, Loans.Adjustable
FROM Loans;
SELECT Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Customers.Address, Customers.City, Customers.State, Customers.ZipCode
FROM Customers;
SELECT Payments.PaymentDate, Payments.AmountReceived AS Total, Payments.AmountReceived AS Average
FROM Payments;
SELECT Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Loans.InterestRate, LoanTypes.LoanName, Loans.Adjustable
FROM Customers INNER JOIN (LoanTypes INNER JOIN Loans ON LoanTypes.Type = Loans.Type) ON Customers.CustomerID = Loans.CustomerID
WHERE (((Loans.Adjustable)=Yes))
ORDER BY Loans.InterestRate DESC;
