Blake_Exp19_Access_AppCapstone_CompAssessment_StudentLoans.accdb
| ClientID |
LastName |
FirstName |
Address |
City |
State |
ZIP |
Email |
Phone |
ExpectedGraduation |
CollegeID |
| 001002 |
Hussein |
Rabiah |
1976 Galleon Way |
Fair Haven |
NJ |
07704 |
rahussein28832@live.com |
600-555-7907 |
2023.0 |
CAM001 |
| 001003 |
Luo |
Hong |
165 Norton Boulevard |
Jersey City |
NJ |
07303 |
hluo25023@hotmail.com |
| 2022.0 |
BLO001 |
| 001006 |
Ramirez |
Javier |
2230 Davis Road |
Caldwell |
NJ |
07007 |
javramirez18105@hotmail.com |
300-555-1094 |
2022.0 |
CAM001 |
| 001007 |
Song |
Myung |
693 Moonlight Lane |
Montville |
NJ |
07045 |
msong22674@live.com |
950-555-7415 |
2021.0 |
ATL001 |
| 001014 |
Zhao |
Jiao |
1087 Brittany Court |
Bloomfield |
NJ |
07003 |
jzhao21097@zohomail.com |
959-555-8227 |
2022.0 |
BRO001 |
| 001022 |
Hamieh |
Casilda |
751 Yar Road |
North Bergen |
NJ |
07047 |
cashamieh20255@aol.com |
351-555-1894 |
2022.0 |
MER001 |
| 001024 |
Ramirez |
Alejandro |
627 King Arthur Boulevard |
Westfield |
NJ |
07091 |
aramirez29743@hotmail.com |
711-555-6926 |
2023.0 |
BLO001 |
| 001034 |
Jhadav |
Kumar |
1331 Edward Avenue |
Haledon |
NJ |
07508 |
kujhadav24231@yahoo.com |
300-555-1656 |
2021.0 |
ROW002 |
| 001039 |
Kwon |
Nam |
1772 Dane Highway |
Newark |
NJ |
07114 |
nakwon16905@mail.com |
976-555-3573 |
2021.0 |
MID001 |
| 001047 |
Tanaka |
Takeshi |
1576 Snead Street |
Jersey City |
NJ |
07307 |
ttanaka23701@hotmail.com |
833-555-8316 |
2023.0 |
ESS001 |
| 001054 |
Hong |
Yon |
2114 Penguin Avenue |
Jersey City |
NJ |
07303 |
yhong11605@zohomail.com |
| 2022.0 |
MID001 |
| 001063 |
Ito |
Kiyoshi |
1837 Tokositna Way |
Fairfield |
NJ |
07004 |
kiyito18713@gmail.com |
711-555-7922 |
2021.0 |
SET001 |
| 001073 |
Hamieh |
Mouna |
1317 List Road |
Newark |
NJ |
07193 |
mouhamieh14649@mail.com |
600-555-8783 |
2023.0 |
OCE001 |
| 001075 |
Li |
Li |
1208 Kilkenny Road |
Jersey City |
NJ |
07304 |
lili17826@zohomail.com |
327-555-3062 |
2021.0 |
COU001 |
| 001083 |
Yamamoto |
Takashi |
985 Shamrock Court |
Irvington |
NJ |
07111 |
tayamamoto17891@optonline.net |
424-555-5848 |
2023.0 |
PRI001 |
| 001085 |
Hayashi |
Yoshio |
1961 Astonshire Road |
Wayne |
NJ |
07470 |
yhayashi10031@optonline.net |
976-555-9592 |
2021.0 |
COL001 |
| 001095 |
Reyes |
Alfredo |
2248 Concourse Road |
Montville |
NJ |
07045 |
areyes11816@ymail.com |
351-555-7519 |
2022.0 |
PAS001 |
| 001102 |
Han |
Mee |
1659 Snug Harbor Avenue |
Glenwood |
NJ |
07418 |
meehan19893@mail.com |
959-555-4420 |
2021.0 |
STO001 |
| 001109 |
Davis |
Dorothy |
1890 Pelican Road |
Clifton |
NJ |
07011 |
dordavis20531@hotmail.com |
969-555-9109 |
2021.0 |
OCE001 |
| 001113 |
Yamaguchi |
Takashi |
2167 Muley Circle |
Fair Lawn |
NJ |
07410 |
tayamaguchi23257@live.com |
424-555-3895 |
2022.0 |
SUS001 |
| 001115 |
Atshan |
Loelia |
2030 Cotton Grass Way |
Hawthorne |
NJ |
07506 |
latshan15480@optonline.net |
711-555-1605 |
2023.0 |
RUT001 |
| 001122 |
Hayek |
Rabiah |
1270 Amherst Place |
South Orange |
NJ |
07079 |
rahayek27170@hotmail.com |
351-555-7882 |
2022.0 |
COU001 |
| 001129 |
Saito |
Yasuo |
153 Totowa Avenue |
Mountain Lakes |
NJ |
07046 |
yasaito29280@gmail.com |
958-555-2833 |
2021.0 |
THO001 |
| 001137 |
Han |
Kyu |
1272 Alascom Boulevard |
Bloomfield |
NJ |
07003 |
khan20969@mail.com |
958-555-9364 |
2022.0 |
MER001 |
| 001146 |
Pawar |
Karthik |
1205 Manhattan Lane |
Elizabeth |
NJ |
07202 |
kapawar22345@optonline.net |
857-555-2627 |
2021.0 |
CEN001 |
| 001152 |
Chavez |
Alejandro |
2046 Denali Place |
Avenel |
NJ |
07001 |
achavez22120@hotmail.com |
833-555-1862 |
2023.0 |
THE001 |
| 001154 |
Nayar |
Jasmine |
2120 Cundiff Way |
Newark |
NJ |
07193 |
jasnayar21112@zohomail.com |
976-555-1824 |
2022.0 |
WAR001 |
| 001161 |
Sanchez |
Ricardo |
530 Anawana Boulevard |
Newark |
NJ |
07199 |
rsanchez14261@gmail.com |
351-555-1519 |
2022.0 |
UNI001 |
| 001162 |
Hamieh |
Cala |
2265 Sommers Lane |
Glenwood |
NJ |
07418 |
cahamieh12082@yahoo.com |
833-555-8418 |
2021.0 |
ROW001 |
| 001165 |
Sanchez |
Alvaro |
947 Reeve Boulevard |
Elizabeth |
NJ |
07202 |
alvsanchez28478@compuserve.com |
969-555-5493 |
2022.0 |
COU001 |
| 001171 |
Evans |
Jennifer |
1604 Berry Patch Avenue |
Carteret |
NJ |
07008 |
jenevans18976@ymail.com |
857-555-3090 |
2021.0 |
ESS001 |
| 001177 |
Wilson |
Daniel |
1266 Sagwon Road |
Oak Ridge |
NJ |
07438 |
dawilson20639@hotmail.com |
600-555-2660 |
2022.0 |
ATL001 |
| 001187 |
Inoue |
Yasuo |
301 Tanglewood Circle |
Hasbrouck Heights |
NJ |
07604 |
yinoue19407@hotmail.com |
969-555-5170 |
2021.0 |
SUS001 |
| 001191 |
Gonzalez |
Riya |
1071 Monarch Court |
Weehawken |
NJ |
07086 |
rigonzalez19132@optonline.net |
857-555-9874 |
2021.0 |
PRI001 |
| 001194 |
Hayashi |
Tadashi |
2199 Graham Place |
Paterson |
NJ |
07544 |
tadhayashi10842@yahoo.com |
998-555-5519 |
2021.0 |
GEO001 |
| 001202 |
Hayashi |
Shigeru |
1047 River Circle |
Alpine |
NJ |
07620 |
shhayashi18319@live.com |
822-555-4556 |
2022.0 |
OCE001 |
| 001204 |
Bishara |
Edelmira |
949 Applewood Terrace |
Roselle Park |
NJ |
07204 |
edbishara19853@zohomail.com |
224-555-8309 |
2023.0 |
SUS001 |
| 001209 |
Hu |
Guo |
2326 The Sun Loft Way |
Linden |
NJ |
07036 |
guhu21124@mail.com |
830-555-9464 |
2022.0 |
PRI001 |
| 001218 |
Kwon |
Min |
2385 Totem Place |
Edgewater |
NJ |
07020 |
mkwon20356@zohomail.com |
833-555-2702 |
2022.0 |
BER002 |
| 001223 |
Flores |
Rodrigo |
1773 Clemens Drive |
Secaucus |
NJ |
07094 |
rflores14960@compuserve.com |
424-555-4759 |
2021.0 |
STO001 |
| 001232 |
Shimizu |
Kazuo |
1813 Baronik Highway |
Boonton |
NJ |
07005 |
kshimizu24175@zohomail.com |
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 |
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;