Re: SQL Server in SBS2000

From: Phil S. (nospam-m-phil-NoSpam_at_123.net)
Date: 06/03/04 

Date: Wed, 2 Jun 2004 20:17:59 -0400

Torrey:

This is no joke. For starting out ---

look for book SQL Server 2000 for Dummies by Anthony T. Mann

Barnes and Nobel has the book for about $25.00 USD, Amazon list a used book
cheaper. There are a couple of other "For Dummies" books on MS SQL.

Just remember, SQL is just the database backend. After you create the
relational database tables and fields, you need a user, or client, front end
to put data into the database, and do something, like create reports, with
the data. Many use MS Access as the front-end.

You are of course welcome to create your own Active Server Pages on your
internal web site and use SQL as the backend of your ASP web page design.
Look for Active Server Pages for Dummies by Bill Hatfield

Trust me on this. These are just beginner books, well written, but beginner
books. Advance books are a WHOLE lot more expensive.

Phil S.

"Torrey Lauer" <anonymous@discussions.microsoft.com> wrote in message
news:E2BE74CE-043E-4780-A6BE-F7BD32B46A12@microsoft.com...
> I would like to setup a database using SQL Server, but I don't even know
where to start. My terminology may be off a little since I've never used
SQL before.
>
> I would like to have several databases that also use forms. The first
database I'd like to create would be used for our outside agents (agents
that aren't in our main office). I'd like to have a place for our agents to
go within our existing agent's only site in order to search for a vendor by
name and/or click on a drop down bar to select the vendor. Once the vendor
is chosen, it would display information that I would have already populated
(ie: vendor's reservation number, vendor's website address, commission
levels that we are at with that particular vendor, and any other notes that
I would have listed for that vendor).
>
> Another database I'd like to have is one for call tracking. I don't know
if this would work for this type of senario, but what I would use it for is
for our agents to create a new "call tracking record" when they take a call.
This would tell us how many calls the agent is taking (ie: if we are able to
use reports to see how many call tracking records the agent created), who
they talked to on that call, what transpired on the call (ie: client wanted
a seven day cruise to the caribbean...wants to visit St. Thomas, St.
Marteen, etc. Two person are going, wants junior suite with balcony...I
quoted $1,500.00 including taxes, without airfare, per person...etc...).
That way, if that agent isn't in the office when that client calls back to
book the cruise or ask more question about the package the agent quoted, we
can pull that record up and read what the agent has already told that
client.
>
> So, I hope I got the idea across on what I'd like to do. Now, what I need
to know is, will SQL work for these senarios? What program do I use to
create the databases? Am I able to work right in SQL to set the databases
up, create the fields, populate the fields, etc...?
>
> I was thinking of using Access to do the call tracking, but I was thinking
that I'd like to have one place to have all this information.
>
> Can anyone provide me with some answers, some go to places to read about
SQL and how to use it, any books that would help me out? I've tried looking
at Microsoft's site about SQL and even did a google search for SQL, but
before I buy any reference books, etc. I'd like to find out some do's,
don't's, be carefuls, this works, that doesn't work, etc. from you guys.
>
> I appreciate any help any and/or direction any of you can provide me!
>
> Thanks!
>
> Torrey Lauer
> Modern Travel Services

Relevant Pages

  • Re: SQL Server in SBS2000
    ... Some require SQL backend. ... > I would like to setup a database using SQL Server, ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Crosstab REPORT, not query
    ... you can use the 'Database Tuning Advisor' against the SQL ... other books on ADP? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL questions
    ... SQL Server can handle this from the database side. ... name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server in SBS2000
    ... setting up SQL Server as the database backend is 'fairly' ... > vendor by name and/or click on a drop down bar to select the vendor. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Need help with update query involving 3 tables
    ... schema of the database, but if you do gain control of it, consider ... > ReviewCount Number - number of reviews of this book ... This table will allow many books to have many authors, ... QueryDef, load the .sql property with an UPDATE statement, and then ...
    (microsoft.public.access.queries)