Depends on your requirement.
If you want to do only simulation and verification then Modelsim better choice.
If you want to do simple simulation and implement the design into an Altera FPGA then you need Quartus.
For making an Altera FPGA using VHDL, you need to have Quartus. You probably will want Modelsim, although the version that comes with Quartus may suffice.