Newbie using SQL

[ILoveMyCorgi]

Can anyone recommend a good reference book, tutorial, and/or online help for
me to learn SQL? We have just converted our databases from Access to SQL.
Thanks.

 

[Jeff Boyce]

Have you converted just the data, and are still using Access as a front-end?
If so, you don't have to learn SQL because you can continue using Access
queries.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ILoveMyCorgi]

No Access... We will be using a SQL server and I've looked at the code, etc.
and feel intimidated with it. I know I can learn this but do not know where
to begin.

 

[Jeff Boyce]

Ahem!...

Use Access! Link to the SQL-Server tables from an Access front-end. Create
a query in Access' design view. Then change the view to the SQL view.
Compare what you did in design view with what SQL Access creates.

You can also use this approach to generate the SQL statement, copy it, and
use it where you need to.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ILoveMyCorgi]

Thank you... not sure how to link the SQL server to an Access front end.
Maybe our network analyst can help me do this. Thanks again.
Susan

 

[Jeff Boyce]

Nope, unless your network analyst knows MS Access.

Open the Access database to the database window. Depending on the version
you are using, you'll be telling Access to get external data, and to "link"
rather than "import" that data.

You will need a SQL-Server Data-Source-Name (your network folks and/or PC
support folks should have an idea on how to do this) that points to the new
SQL-Server database where the tables/data now lives.

You'll use the DSN to connect to those. Once you have "linked tables", you
can create queries as usual.

Regards

Jeff Boyce
Microsoft Office/Access MVP