Re: Relational Databases

www.vtco.com ...which is free now...has an Access Tutorial.

At 01:40 PM 4/7/00 -0400, Paul Kmecak wrote:
>Matt,
>
>I don't know about online tutorials, but if you have working queries in an
>Access database, even the Northwind and Solutions sample databases that come
>with Access, select a query, click the "Design" button, click the down
arrow on
>the "View" button in the upper left and select SQL View.  This displays
the SQL
>in back of the query.  Then, just position the cursor over a(n) SQL term
and hit
>F1 or look it up in Help.  I have learned a LOT of things just by checking
out
>Help.
>
>I can also recommend the "Access 97 Developer's Handbook" from Sybex (ISBN
>0-7821-1941-7).  Lots of tutorials, explanations, examples, source code,
>including a handy-dandy CD.
>
>Matt Savage wrote:
>
>> <stephen>I just want people to realize that CF is not the answer for
>> database transparency, it is really good coding and knowledge of the cross
>> DB capabilities exposed by ODBC that allow for this</stephen>
>>
>> I have been looking into the possibility of working with HTML generated
from
>> databases for some time and following this discussion has been a great help
>> to me- thankyou everyone.
>>
>> I like the idea of database transparency aluded to in the above posting.
>> I've been looking at using Cold Fusion (as someone said, the $500 price tag
>> for just the development kit is fine if you can recover it in time savings
>> later) but I don't want to surrender control (or understanding) of the
>> processes going on underneath. For much the same reasons I don't use Home
>> Site. In order to get my head round this database thing I think I am
finally
>> going to have to bite the bullet and learn more about SQL. I'm pretty
hot on
>> Access and general relational database theory, but have no idea whatsoever
>> how to use SQL.
>>
>> Does anyone have any good suggestions for online tutorials etc.?
>>
>> Any other related information I need to look for? (I'm considering taking
>> the long route, like Ben Ocean, and using PHP and MySQL)
>>
>> TIA
>>
>> -Matt
>>
>> PS- Go easy on me with the tutorials- I'm new to this. Just a foot on the
>> ladder is all I need to start with.
>> ______________________________________________________
>> Get Your Private, Free Email at http://www.hotmail.com
>
>
Melanie Gann
Second Street Web Design
www.second-street.com

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA