Where to begin learning about datbases ?

E

Emmy

Hi,

I've got an Excel file with more than three thousand records.
Each record (or line) contains the attributes of one book in eight columns
(author, name, editor, etc).
I would like my visitors to search the file asking for keywords, such as
Borges, or Spain, or Architecture, etc.
Then they would link to a page with the records that contain that specific
word (no matter in which column it is) and no other one.
Of course I will need to add and delete records but not often.

I know nothing of databases but I can manage using Frontpage 2002.
I will probably use Tripod for the hosting if they answer me that they have
ASP and IIS enabled server.

Am I supposed to use Access or can I use the Excel file ?
Where can I learn about this ? I've been looking in the Help within FP but I
don't like it, it's not clear enough.
Thanks in advance !

Emmy
 
T

Thomas A. Rowe

1. Tripod is not going to be able to handle this as they run Unix/Linux servers which do not allow
the use of ASP or Access.

2. You want a Windows based web host that supports Access with the ability to upgrade at some point
to MS SQL server.

3. You would want to use Access, not Excel.

4. You will need to be willing to learn to code in ASP/VBScript, as you can start out using the FP
database components, but will find that is has limitations, as your needs grow, and they will once
you see what a database driven web site can do.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
E

Emmy

It seems more difficult than what I was thinking on !

My English is not so good...you meant that I could start using FP database
components, but then I will need to code in ASP/VBScript, as my database
grows ...?
And if I want to do it that way, where can I learn how to use FP database
components ?

Thanks for all !
Emmy
 
T

Thomas A. Rowe

Emmy,

Yes, you could start with the FP Database component, do search under help. As your site grows, as
well as your needs, you will need to learn ASP/VBScript so that you can code some of the function
directly that FP's database component doesn't support or doesn't handle well.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
E

Emmy

Thanks for your answer Thomas !
but don't forget to tell me where can I start learning FP database
components ?

Emmy
 
T

Thomas A. Rowe

FP Help.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top