SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL server vs Access in the job market


SQL server vs Access in the job market

Author
Message
geuncho6
geuncho6
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 116
I am currently working with SQL server for my current job, but still am not an expert. As you know SQL server is very broad and deep sets of multiple technologies that will get bigger and broader.

I am beginning to wonder, will it be wiser to shift my area of concentration from SQL server to Microsoft Access? The reason being that large # of small to medium, and even big fortune 500 companies cannot operate without Access. I know that some local governments' detention center are still operating with Access for inmate management. Another reason is that it's easier and takes less time to develop expertise in my opinion.

Your opinion?
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8645 Visits: 7660
Major paycut and limitations as to what you can do with MS Access.

It takes time to be an expert in either, honestly. You're right, MSAccess is a powerful tool for smaller businesses, but do you want a job with a company that has nowhere for you to go once you've got them on track?

MSAccess is usually where you start, not where you end up, if you have the choice.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32751 Visits: 18559
Also consider that most DBAs do not consider Access as a Database. It is something more typically used by business persons to achieve a short term goal without long-term planning.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

geuncho6
geuncho6
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 116
Well, IMHO, at least to me, I don't care at all about where the company is going or whether it's a long term or short term solution. In this day and age, the management at the companies are over-stretching the limits of free and cheap solutions before considering enterprise level solutions. In these kind of situations, what I'm interested in is whether my skill will get me a job and retain job with least competition and most ease whether it be MS Access or SQL or mySQL or whatever.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29303 Visits: 9671
Sql server has sql express R2 which allows you to store 10 GB of data (5 times more than access last time I checked).

That version is free and only has CPU and RAM limitations. Extremely viable replacement for access... which can still be used as the front end rather than data store.
jshahan
jshahan
Mr or Mrs. 500
Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)Mr or Mrs. 500 (550 reputation)

Group: General Forum Members
Points: 550 Visits: 2086
It's been a few years since I've had to work with Access but I don't miss it much. There were several shortcomings such as 1) Trying to do complex queries in that awful query designer, 2) the database expanding everytime a temporary table is created and having to contract it manually, and 3) The possibility of the entire database becoming corrupt and unusuable.

Given a choice and especially with the advent of Reporting Services, I would never choose a career in Access as opposed to SQL Server.
RonKyle
RonKyle
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2770 Visits: 3501
Also consider that most DBAs do not consider Access as a Database


Access may not be an enterprise level database, but it is a database. Like any tool, there are things it is very appropriate for, and other things for which it is not at all suited. I have seen lots of "tiny" databases put on SQL Server that should have been Access databases. Instead they sucked time and resources from the databases that should have been on there.

Personally, I enjoy working with both.



Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29303 Visits: 9671
RonKyle (8/9/2011)
Also consider that most DBAs do not consider Access as a Database


Access may not be an enterprise level database, but it is a database. Like any tool, there are things it is very appropriate for, and other things for which it is not at all suited. I have seen lots of "tiny" databases put on SQL Server that should have been Access databases. Instead they sucked time and resources from the databases that should have been on there.

Personally, I enjoy working with both.



+1 Actually Access used as front-end + sql server as back end is a dream to develop in. I might preffer SSRS for reporting capabilities but only because I've not really explored the access reports that much.
GregoryF
GregoryF
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1188 Visits: 885
Access would probably pay no more than 60% of what SQL pays. Myself, and many DBA's like me would not consider Access to be a database and a person who work in access is a Access Developer, not in any form a DBA. Sorry, but it's the brutal truth. Besides, I'm not sure is access is even technically a RDBMS on the back end.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
jd 60382
jd 60382
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 400
As someone that has been around the industry since the 0.1b days of Access and Sql Server 7 and before...(the brain fogs with age sometimes) the question you pose is not an easy one to answer.

While it is true that many small and medium size companies have and are using Access, finding jobs with them may not be the easiest thing to accomplish.

While I have to agree that where the opportunity presents itself, using Access as a front end to a SQL back-end; whether express or enterprise is a pleasure to work with and in, the reality of finding businesses that will pay a living wage for someone with Access skills compared to someone with SQL skills in most areas in the country today is like searching for the proverbial needle in a haystack.

My two cents is to concentrate on SQL and if you are targeting smaller businesses as a generalist, not specifically as a DBA, then get up to speed with .NET and web based access to data.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search