Ya if your doing a simple website frontpage is fine. However if you want to get into advanced web design you would want to look into dreamweaver. Just go direct to Macromedia's website and download it there. Just download Studio 8. That consists of dreamweaver, Fireworks, Flash8 Pro, MX Freehand & coldfusion. That suite will give you the ability to do whatever you want.
It is alot more in depth than frontpage. Just search books on Dreamweaver and you'll find thousands of them. They have plenty of templates that should help guide you till you get a feel for the software though. Trust me though after you learn Studio8 you'll never want to go back to frontpage again!