I assume your a complete newbie: like you say, "im new to the web site creation
world !! "
Starting out with a database site is a big step (call it a giant leap) up from a
static basic site.
Bryan, you might want to start simple and work you way up to database driven
sites (I've been using frontpage for 7 years, and have only this year worked my
way into the database/asp stuff that frontpage offers).
This site is a good one to begin with (frontpage tutorial on all aspects of
frontpage including databases).
www.frontpagewiz.com
Note, however that Frontpage's limitations on database integration - you may have
to learn ASP programming in the long term to be really flexible with what you
want to do.
Databases in terms of the web are used for all sorts of things from being the
back-end of a complete content management system to discussion boards and the
like.