sql server

Posted on 2012-08-19
Last Modified: 2012-08-19
I am about to interview for a position- I use microsoft access and visual basic at present postition now.I either code in the sql statement or use the user friendly design view interface to create forms and reports sometimes.

question: The position I am interviewing for uses both microsoft access and sql server.
Is anything in sql server similar to access? and is there some simple tutorial to view online that will at least give me a simple idea of how it looks?
( I used oracle sql in college and it was completely text and no interfaces.)
thank you
Question by:davetough
    LVL 65

    Accepted Solution


    But, just to get it out of the way ... if you're asking the question, then you're likely not qualified for the SQL Server part.

    Knowledge that can transfer from Access to SQL Server:
    * Access table structure, relationships, and keys
    * Data types will be a low learning curve
    * The concept of Access linked tables / SQL linked servers
    * Access SQL, depending on how good you are at it and not dependant on the designer, is a decent starting point to learn SQL Server T-SQL
    * Access VBA coding, depending on how good you are at it, will give you a decent starting point for learning SQL Server T-SQL

    None of your UI experience in Access (forms, reports) will transfer to SQL.

    Good luck on the interview.

    Author Comment

    thanks - hopefully they are willing to hire someone with no sql experience- most of these jobs I see posted - want experience in about 6 to 10 different things- programming languages- different database platforms- ( maybe there are alot of people out there with all that experience- but college did not prepare but with some basics- and my present job would never use sql server or oracle when they can just use access- which already installed on pc's-
    thanks for the help
    LVL 65

    Expert Comment

    by:Jim Horn
    one correction

    *  Access reports should transfer pretty well to SQL Server Reporting Services (SSRS)

    None of your forms UI experience in Access will transfer to SQL.

    >want experience in about 6 to 10 different things- programming languages
    I've been out of college for 20ish years, and I've rarely seen a job description that was an exact match of the job.  Many of them include a bunch of 'wish list' things, or is a watered-down version that HR wrote to be compatible with jobs at the same level, or was re-worded by a recruiter to serve their own purposes.    

    Best advice I can give you is to make contact with the hiring manager, and ask them point-blank what they're trying to hire for.

    Also, rarely will hiring managers write about how wonderfully diverse the company is, and that we're all bright shiny happy people and every day at work we sing zippity-doo-dah out of our <okay, rant over>

    Keep plugging away, the offer(s) will eventually come.

    Thanks for the grade.  Good luck with your interview.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    729 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

    21 Experts available now in Live!

    Get 1:1 Help Now