Vancouver is definitely a good place study Accounting. As for safe and affordable areas to live, you can consider East Vancouver (Killarney, Collingwood, Kingsway & Knight area). Burnaby area is also fairly inexpensive.
I also agree with Evayin, you should check out RentGeek because it matches your requirements (through a survey) to areas in Vancouver. It might be a good place to start.