Solved

Learning SQL Server (already know Access)

Posted on 2013-12-16
4
368 Views
Last Modified: 2013-12-19
Hi,

Is it difficult to learn SQL Server?

I am self-taught Microsoft Access and have developed several small databases for commercial clients.
0
Comment
Question by:Patrick O'Dea
4 Comments
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 167 total points
ID: 39722853
Not necessarily but SQL Server is Only a server, it does not have a built-in front end like Access does.  You need a program like SQL Server Management Studio or the ability to write your own code in a programming language to use it.  You could start by downloading and installing one of the SQL Server Express versions and the SQL Server Management Studio that goes with it.  Info here: http://www.microsoft.com/web/platform/database/free-database.aspx
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 167 total points
ID: 39722859
Easy is a relative term I'm sure.
I can recommend this site in any case. And you can watch the first 3-4 interactive lessons free.  And ~$30/month - cancel anytime for the entire catalog ... not bad.

http://www.vtc.com/databases.htm

mx
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 166 total points
ID: 39722984
It's not really bad, although it will be a bit before you become a wiz at T-SQL.  But to get up to speed on the basics, no.  It's pretty straight forward.

If you've worked with SQL in Access, you just need to make some adjustments.

Jim.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39728923
Thanks for comments.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now