Exp19_Access_AppCapstone_CompAssessment_Student Loans
lacey.xyY
Blake_Exp19_Access_AppCapstone_CompAssessment_StudentLoans.accdb| ClientID | LastName | FirstName | Address | City | State | ZIP | Phone | ExpectedGraduation | CollegeID | |
|---|---|---|---|---|---|---|---|---|---|---|
| 001002 | Hussein | Rabiah | 1976 Galleon Way | Fair Haven | NJ | 07704 | [email protected] | 600-555-7907 | 2023.0 | CAM001 |
| 001003 | Luo | Hong | 165 Norton Boulevard | Jersey City | NJ | 07303 | [email protected] | 2022.0 | BLO001 | |
| 001006 | Ramirez | Javier | 2230 Davis Road | Caldwell | NJ | 07007 | [email protected] | 300-555-1094 | 2022.0 | CAM001 |
| 001007 | Song | Myung | 693 Moonlight Lane | Montville | NJ | 07045 | [email protected] | 950-555-7415 | 2021.0 | ATL001 |
| 001014 | Zhao | Jiao | 1087 Brittany Court | Bloomfield | NJ | 07003 | [email protected] | 959-555-8227 | 2022.0 | BRO001 |
| 001022 | Hamieh | Casilda | 751 Yar Road | North Bergen | NJ | 07047 | [email protected] | 351-555-1894 | 2022.0 | MER001 |
| 001024 | Ramirez | Alejandro | 627 King Arthur Boulevard | Westfield | NJ | 07091 | [email protected] | 711-555-6926 | 2023.0 | BLO001 |
| 001034 | Jhadav | Kumar | 1331 Edward Avenue | Haledon | NJ | 07508 | [email protected] | 300-555-1656 | 2021.0 | ROW002 |
| 001039 | Kwon | Nam | 1772 Dane Highway | Newark | NJ | 07114 | [email protected] | 976-555-3573 | 2021.0 | MID001 |
| 001047 | Tanaka | Takeshi | 1576 Snead Street | Jersey City | NJ | 07307 | [email protected] | 833-555-8316 | 2023.0 | ESS001 |
| 001054 | Hong | Yon | 2114 Penguin Avenue | Jersey City | NJ | 07303 | [email protected] | 2022.0 | MID001 | |
| 001063 | Ito | Kiyoshi | 1837 Tokositna Way | Fairfield | NJ | 07004 | [email protected] | 711-555-7922 | 2021.0 | SET001 |
| 001073 | Hamieh | Mouna | 1317 List Road | Newark | NJ | 07193 | [email protected] | 600-555-8783 | 2023.0 | OCE001 |
| 001075 | Li | Li | 1208 Kilkenny Road | Jersey City | NJ | 07304 | [email protected] | 327-555-3062 | 2021.0 | COU001 |
| 001083 | Yamamoto | Takashi | 985 Shamrock Court | Irvington | NJ | 07111 | [email protected] | 424-555-5848 | 2023.0 | PRI001 |
| 001085 | Hayashi | Yoshio | 1961 Astonshire Road | Wayne | NJ | 07470 | [email protected] | 976-555-9592 | 2021.0 | COL001 |
| 001095 | Reyes | Alfredo | 2248 Concourse Road | Montville | NJ | 07045 | [email protected] | 351-555-7519 | 2022.0 | PAS001 |
| 001102 | Han | Mee | 1659 Snug Harbor Avenue | Glenwood | NJ | 07418 | [email protected] | 959-555-4420 | 2021.0 | STO001 |
| 001109 | Davis | Dorothy | 1890 Pelican Road | Clifton | NJ | 07011 | [email protected] | 969-555-9109 | 2021.0 | OCE001 |
| 001113 | Yamaguchi | Takashi | 2167 Muley Circle | Fair Lawn | NJ | 07410 | [email protected] | 424-555-3895 | 2022.0 | SUS001 |
| 001115 | Atshan | Loelia | 2030 Cotton Grass Way | Hawthorne | NJ | 07506 | [email protected] | 711-555-1605 | 2023.0 | RUT001 |
| 001122 | Hayek | Rabiah | 1270 Amherst Place | South Orange | NJ | 07079 | [email protected] | 351-555-7882 | 2022.0 | COU001 |
| 001129 | Saito | Yasuo | 153 Totowa Avenue | Mountain Lakes | NJ | 07046 | [email protected] | 958-555-2833 | 2021.0 | THO001 |
| 001137 | Han | Kyu | 1272 Alascom Boulevard | Bloomfield | NJ | 07003 | [email protected] | 958-555-9364 | 2022.0 | MER001 |
| 001146 | Pawar | Karthik | 1205 Manhattan Lane | Elizabeth | NJ | 07202 | [email protected] | 857-555-2627 | 2021.0 | CEN001 |
| 001152 | Chavez | Alejandro | 2046 Denali Place | Avenel | NJ | 07001 | [email protected] | 833-555-1862 | 2023.0 | THE001 |
| 001154 | Nayar | Jasmine | 2120 Cundiff Way | Newark | NJ | 07193 | [email protected] | 976-555-1824 | 2022.0 | WAR001 |
| 001161 | Sanchez | Ricardo | 530 Anawana Boulevard | Newark | NJ | 07199 | [email protected] | 351-555-1519 | 2022.0 | UNI001 |
| 001162 | Hamieh | Cala | 2265 Sommers Lane | Glenwood | NJ | 07418 | [email protected] | 833-555-8418 | 2021.0 | ROW001 |
| 001165 | Sanchez | Alvaro | 947 Reeve Boulevard | Elizabeth | NJ | 07202 | [email protected] | 969-555-5493 | 2022.0 | COU001 |
| 001171 | Evans | Jennifer | 1604 Berry Patch Avenue | Carteret | NJ | 07008 | [email protected] | 857-555-3090 | 2021.0 | ESS001 |
| 001177 | Wilson | Daniel | 1266 Sagwon Road | Oak Ridge | NJ | 07438 | [email protected] | 600-555-2660 | 2022.0 | ATL001 |
| 001187 | Inoue | Yasuo | 301 Tanglewood Circle | Hasbrouck Heights | NJ | 07604 | [email protected] | 969-555-5170 | 2021.0 | SUS001 |
| 001191 | Gonzalez | Riya | 1071 Monarch Court | Weehawken | NJ | 07086 | [email protected] | 857-555-9874 | 2021.0 | PRI001 |
| 001194 | Hayashi | Tadashi | 2199 Graham Place | Paterson | NJ | 07544 | [email protected] | 998-555-5519 | 2021.0 | GEO001 |
| 001202 | Hayashi | Shigeru | 1047 River Circle | Alpine | NJ | 07620 | [email protected] | 822-555-4556 | 2022.0 | OCE001 |
| 001204 | Bishara | Edelmira | 949 Applewood Terrace | Roselle Park | NJ | 07204 | [email protected] | 224-555-8309 | 2023.0 | SUS001 |
| 001209 | Hu | Guo | 2326 The Sun Loft Way | Linden | NJ | 07036 | [email protected] | 830-555-9464 | 2022.0 | PRI001 |
| 001218 | Kwon | Min | 2385 Totem Place | Edgewater | NJ | 07020 | [email protected] | 833-555-2702 | 2022.0 | BER002 |
| 001223 | Flores | Rodrigo | 1773 Clemens Drive | Secaucus | NJ | 07094 | [email protected] | 424-555-4759 | 2021.0 | STO001 |
| 001232 | Shimizu | Kazuo | 1813 Baronik Highway | Boonton | NJ | 07005 | [email protected] | 300-555-7418 | 2021.0 | STO001 |
| CollegeID | CollegeName | Address1 | City | State | Zip | Phone |
|---|---|---|---|---|---|---|
| ATL001 | Atlantic Cape Community College | 5100 Black Horse Pike | Mays Landing | NJ | 08330 | 609-555-4900 |
| BER001 | Bergen Community College | 400 Paramus Road | Paramus | NJ | 07652 | 201-555-7100 |
| BER002 | Berkeley College | 44 Rifle Camp Road | Woodland Park | NJ | 07424 | 973-555-5400 |
| BLO001 | Bloomfield College | 467 Franklin St | Bloomfield | NJ | 07003 | 973-555-9000 |
| BRO001 | Brookdale Community College | 765 Newman Springs Road | Lincroft | NJ | 07738 | 732-555-2345 |
| CAL001 | Caldwell University | 120 Bloomfield Avenue | Caldwell | NJ | 07006 | 973-555-3000 |
| CAM001 | Camden County College | P.O. Box 200 | Blackwood | NJ | 08012 | 856-555-7200 |
| CEN001 | Centenary College | 12-56 Califon Rd | Long Valley | NJ | 07853 | 908-555-7010 |
| COL001 | College of Saint Elizabeth | 2 Convent Road | Morristown | NJ | 07960 | 973-555-4000 |
| COU001 | County College of Morris | 214 Center Grove Road | Randolph | NJ | 07869 | 973-555-5000 |
| CUM001 | Cumberland County College | P.O. Box 1500, College Drive | Vineland | NJ | 08362 | 856-555-8600 |
| DEV001 | DeVry University | 630 U.S. Highway One | North Brunswick | NJ | 08902 | 732-555-3960 |
| DRE001 | Drew University | 36 Madison Avenue | Madison | NJ | 07940 | 973-555-3000 |
| EAS001 | Eastwick College | 250 Moore Street | Hackensack | NJ | 07601 | 201-555-9400 |
| ESS001 | Essex County College | 303 University Ave. | Newark | NJ | 07102 | 973-555-3000 |
| FAI001 | Fairleigh Dickinson University | 1000 River Road | Teaneck | NJ | 07666 | 800-555-8803 |
| FEL001 | Felician College | One Felician Way | Rutherford | NJ | 07070 | 201-555-6000 |
| GEO001 | Georgian Court University | 900 Lakewood Ave | Lakewood | NJ | 08701 | 800-555-8422 |
| HUD001 | Hudson County Community College | 70 Sip Avenue | Jersey City | NJ | 07306 | 201-555-7100 |
| KEA001 | Kean University | 1000 Morris Avenue | Union | NJ | 07083 | 908-555-5326 |
| MER001 | Mercer County Community College | 1200 Old Trenton Road | West Windsor | NJ | 08550 | 609-555-4800 |
| MID001 | Middlesex County College | 2600 Woodbridge Ave. | Edison | NJ | 08818 | 732-555-6000 |
| MON001 | Monmouth University | 400 Cedar Avenue | West Long Branch | NJ | 07764 | 732-555-3400 |
| MON002 | Montclair State University | 1 Normal Ave | Montclair | NJ | 07043 | 973-555-4000 |
| NEW001 | New Jersey City University | 2039 Kennedy Boulevard | Jersey City | NJ | 07305 | 201-555-2000 |
| NJI001 | NJIT | University Heights | Newark | NJ | 07102 | 973-555-3000 |
| OCE001 | Ocean County College | College Drive, P.O. Box 2001 | Toms River | NJ | 08754 | 732-555-0400 |
| PAS001 | Passaic County Community College | One College Blvd. | Paterson | NJ | 07505 | 973-555-6868 |
| PRI001 | Princeton University | Princeton University | Princeton | NJ | 08544 | 609-555-3000 |
| RAM001 | Ramapo College of New Jersey | 505 Ramapo Valley Road | Mahwah | NJ | 07430 | 201-555-7500 |
| RAR001 | Raritan Valley Community College | 118 Lamington Road | Branchburg | NJ | 08876 | 908-555-1200 |
| ROW001 | Rowan College at Gloucester County | 1400 Tanyard Road | Sewell | NJ | 08080 | 856-555-5000 |
| ROW002 | Rowan University | 201 Mullica Hill Road | Glassboro | NJ | 08028 | 856-555-4000 |
| ROW003 | Rowan College at Burlington County | 601 Pemberton Browns Mills Road | Pemberton | NJ | 08068 | 609-555-9311 |
| RUT001 | Rutgers | 190 University Ave | Newark | NJ | 07102 | 973-555-1766 |
| SAI001 | Saint Peter's University | 2641 John F. Kennedy Boulevard | Jersey City | NJ | 07306 | 888-555-9933 |
| SAL001 | Salem Community College | 460 Hollywood Ave. | Carney's Point | NJ | 08069 | 856-555-2100 |
| SET001 | Seton Hall University | 400 South Orange Avenue | South Orange | NJ | 07079 | 973-555-9000 |
| STE001 | Stevens Institute of Technology | Castle Point on Hudson | Hoboken | NJ | 07030 | 201-555-5000 |
| STO001 | Stockton University | 101 Vera King Farris Drive | Galloway | NJ | 08205 | 609-555-1776 |
| SUS001 | Sussex County Community College | One College Hill | Newton | NJ | 07860 | 973-555-2100 |
| THE001 | The College of New Jersey | 2000 Pennington Road | Ewing | NJ | 08628 | 609-555-2131 |
| THO001 | Thomas Edison State College | 101 West State Street | Trenton | NJ | 08608 | 888-555-8372 |
| UNI001 | Union County College | 1033 Springfield Ave. | Cranford | NJ | 07016 | 908-555-7000 |
| UNI002 | University of Phoenix, Jersey City Campus | 100 Town Square Place | Jersey City | NJ | 07310 | 866-555-0766 |
| WAR001 | Warren County Community College | 475 Route 57 West | Washington | NJ | 07882 | 908-555-9222 |
| WIL001 | William Paterson University of New Jersey | 300 Pompton Rd | Wayne | NJ | 07470 | 973-555-2000 |
| ID | mSysRowId |
|---|---|
| 1 |
SELECT Clients.LastName, Clients.FirstName, Clients.Email, Clients.Phone, Clients.ExpectedGraduation, Colleges.CollegeName
FROM Colleges INNER JOIN Clients ON Colleges.CollegeID = Clients.CollegeID
WHERE (((Clients.ExpectedGraduation)=2022))
ORDER BY Clients.LastName, Clients.FirstName;
