Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

sql server

Hello,
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
0
davetough
Asked:
davetough
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Yes

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.
Jim
0
 
davetoughAuthor Commented:
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
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now