First off, welcome to the forums. Next, I come from a MS background myself. While Microsoft has some easy to use products, personally I feel that you would be much better off using something other than Frontpage. However, saying that, Frontpage has that HTML tab...use it to see what is going on "behind the scenes". You'll find you'll learn a lot rather quickly. Regarding databases, if you're going to do that type of site, you would be MUCH better off using MySQL instead of Access. (As already pointed out...MySQL is supported here.) There's always a learning curve when starting out in a new adventure (some more than others). I would also recommend the "...For Dummies" books. I have several and I have learned quite a bit from them.
Last but not least, there's always the family that you can bounce questions off of...as you're doing now! Good luck!
(The preceding was my own opinion. Others opinions may vary!)