I worked my way through college while holding a full time job and paying my own rent with no college loans. Yeah it's affordable.
I did the same. I also paid for my wife's education as an RN.
The best thing to do if you seek a degree is to get something that WILL land you a job. My wife was hired before she even left school. And, there were hospitals willing to help pay for her school.