Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Oct 2009
    Posts
    3

    Unanswered: When should i start to learn SQL or SQL Server

    Hi all,

    Apologises in advance for the long windedness of this post and also what ever mistakes I may make. This is my first time writing on a forum, I usually just read them and take snippets of info from here and there.

    Anyway to my point! I am Data Analyst that is self taught in MS Access (2003). I have been able to utilise the knowledge I have to create applications that automate a variety of tasks that were previously manually carried out in arduous .xls worksheets. Well the tools(applications) I have created are now being used multiple user and I have created Front End/Back End systems, I have also taught my self some basic (anthesis on basic) VBA mainly Docmd features and such.

    Well now my manager needs to set the budget for the coming year and has asked if I will needed any future training. I am due to have official VBA for Access training next week but I am not sure what I may need in the not to distant future. Reading forums on line it seems like i should be learning SQL or SQL server but I am not to sure...and I would need to justify any suggested course with plausible reasoning.

    Can any body see what software training maybe useful for me or offer any advice. I am sorry for the waffling in this post, I just hope I have explained my situation in a way that some one will be able to assist me.

    Many thanks in advance,

    GDA

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the only plausible reason for learning SQL Server on your boss's dime is if you are going to use SQL Server on the job

    learn SQL, because it will strengthen immensely your Access skills

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2009
    Posts
    3
    Thanks r937

    How will knowing SQL improve my skills? Sorry I am just pre-empting his question?

    Regards

    GDA

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why don't you run through the examples A Gentle Introduction to SQL first?
    Lovely free resource
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you're writing reports, creating queries, making clever data forms (bound and unbound) then knowing SQL will help immensly.

    Obviously it doesn't help in all aspects of Access but because most of the time we use Access for data-driven applications; why not learn more of the foundations
    George
    Home | Blog

  6. #6
    Join Date
    Oct 2009
    Posts
    3
    Hi Gvee,

    I will do thank you.

    And thank you guys for you quick responses it is greatly appreciated.

    GDA

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    At some point those Access applications are going to need to be upsized to SQL Server.
    Either you will be the one to do it, or you will be the one the high-priced consultant refers to derogatorily while he does it.
    Career-wise, I'd going with option A.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    When should i start to learn SQL or SQL Server
    Yesterday?

    And the boys didn't tell ya...but Access ain't no database
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes, Access is a database....
    Don't be hatin', bro.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by blindman
    Yes, Access is a database....
    No, it's not - at least not a relational database
    It's a front end to a database, a pretty slick front end, but still a front end.

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by shammat
    No, it's not - at least not a relational database
    yes it is

    it supports primary and foreign keys, it has a wide variety of supported JOINs, and it supports (most of) the SQL language

    okay, Access SQL has some quirks, but then, every SQL implementation has quirks... empty string as NULL, anyone?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yes, Access is a relational database. With a front-end and reporting application built in.
    Sheesh.....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    OK then...Lotus Notes is a database
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Brett Kaiser
    OK then...Lotus Notes is a database
    so's my rolodex, then
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Lotus Notes is a datapile.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •