Results 1 to 7 of 7

New to SQL

  1. #1
    Agharti is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    1

    New to SQL

    Hi,

    I kept developing simple databases that did not require sql solution but recently it is starting to be not sufficient, I have more and more demanding customers and I need to start using SQL.

    My question is which book you could recommend for someone new to SQL? I got quite a good grip on access itself and starting to be quite confident with VBA.

    Also what software would you recommend? Obviously the cheaper the better. I was looking into Microsoft SQL Express edition but maybe you have different view.

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,236
    My favorite book is the "Microsoft Access Developer's Guide to SQL Server" by Chipman and Baron. It's a bit dated, but the concepts are still relevant. I've only used the various full versions of SQL Server, since my employer owns them. I've heard that the Express version works well.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Express is great for getting started. Hard to beat free.

  4. #4
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101

    New to SQL

    Hi All,

    I have been reading this thread, I have a simular question.
    If I install Microsoft SQL Express edition, what will this give?

    I wish to begin using SQL Server to create databases but unsure how to begin!!

    Looking for guidance??

    Thanks

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,236
    My friend Leigh has a comprehensive primer here:

    http://www.utteraccess.com/forum/Beg...-t1732935.html
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  6. #6
    bigroo's Avatar
    bigroo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jan 2012
    Location
    Austin, Texas
    Posts
    101
    Hi Pbaldy,

    Wow, some reading there, it will take a little time to digest it all and understand my next steps, thanks for sharing!!

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,236
    No problem! There is certainly a lot of info there.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums