Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Display Modes
  #11  
Old 02-26-2016, 06:10 PM
MathStatFin's Avatar
MathStatFin MathStatFin is offline
Member
Non-Actuary
 
Join Date: Jul 2014
Posts: 4,194
Default

It's like microsoft is the middleman between ordinary people and stuff that already exists as linux executables.
Reply With Quote
  #12  
Old 02-26-2016, 08:20 PM
Arlie_Proctor Arlie_Proctor is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: N.J.
College: Indiana University
Favorite beer: Becks
Posts: 1,165
Default

Quote:
Originally Posted by lit041000 View Post
We have sql too. Access likes to get these 'mystery bugs' with no explanation and no error messages. I just spent 3 hours staring at the same mysteriously broken form, praying for death to take me peacefully.
Woe to he who chooses to use forms or reports in an Access database. There is no greater evil unless the form/report is incredibly simple.
Reply With Quote
  #13  
Old 02-27-2016, 10:28 AM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,747
Default

BTDT.

I will never accept a job where management doesn't know what a data frame is ever again. Same to management which believes that SQL Server is too expensive.
__________________
If you want to add me on LinkedIn, PM me.

Why I hate Microsoft Access.

Studying/Reading: Statistical Inference, Bayesian Data Analysis
Reply With Quote
  #14  
Old 02-27-2016, 12:34 PM
Hartke Hartke is offline
Member
SOA
 
Join Date: Apr 2015
Posts: 2,417
Default

I have been working since the day I started this job to convert anything in access to SQL.

The only real advantage of access if you dont need any permissions to use it (DB can be stored on the network drive with few questions). Anyone at a big company prob knows how much a PITA IT is when dealing with SQL (server space is admin by IT). That and then your group will be charged for the server space so you get brain numbing comments from management like 'cant we just do that in excel for free?'

Last edited by Hartke; 02-27-2016 at 12:38 PM..
Reply With Quote
  #15  
Old 02-27-2016, 04:31 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 88,073
Default

One can configure MS-SQL to allow MS Access to extract data and to import data to MS SQL.
It is a nice learning/transition tool for those who are more visual learners with the joining lines and the boxes. Then, when a user has learned enough about coding, he can then graduate to SQL with somewhat ease.

At least, that's how I learned.
__________________
DTNF's Basic Philosophy Regarding Posting: There's no emoticon for what I'm feeling! -- Jeff Albertson (CBG)
DTNF's Trademarked Standard Career Advice: "pass some exams and get back to us."
DTNF's Major advice: "Doesn't matter. Choose major that helps you with goal of Career Advice."
DTNF's Résumé Advice: Have a good and interesting answer to every item on it for the interviews.
DTNF's Law of Job Offers: You not only have to qualify for the position, but you also have to be the best candidate available for the offer.
DTNF's Work Philosophy: I am actuary. Please insert data. -- Actuary Actuarying Rodriguez.
Twitches' Advice to Crazy Women: Please just go buy your 30 cats already.
Reply With Quote
  #16  
Old 02-27-2016, 09:44 PM
Arlie_Proctor Arlie_Proctor is offline
Member
CAS AAA
 
Join Date: Dec 2001
Location: N.J.
College: Indiana University
Favorite beer: Becks
Posts: 1,165
Default

Actually, I would prefer that new users learn things the other way around. Once you're proficient with SQL, Access is a decent front end tool for accessing an RDBMS. If you start with it's graphical query designer before you understand basic SQL, you learn some things the hard way.
Reply With Quote
  #17  
Old 02-27-2016, 09:49 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 36,396
Default

Quote:
Originally Posted by Arlie_Proctor View Post
Actually, I would prefer that new users learn things the other way around. Once you're proficient with SQL, Access is a decent front end tool for accessing an RDBMS. If you start with it's graphical query designer before you understand basic SQL, you learn some things the hard way.
That happened to me. I learned SQL first. The software manual was a surprisingly good learning tool - I suppose it helped that I knew a variety of languages already. When my employer got Access, it was very easy to transition - and I could edit the Access-generated code if it made sense to do so.

I never used Access forms, though.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Oct 13, 2017.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
Quote:
Originally Posted by Bro View Post
I recommend you get perspective.
Quote:
Originally Posted by Enough Exams Already View Post
Dude, you can't fail a personality test. It just isn't that kind of test.
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Reply With Quote
  #18  
Old 05-16-2017, 03:59 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is online now
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,688
Blog Entries: 1
Default

*@#$ Access!

I just inherited 3 sets of 10 spreadsheets that communicate to 3 'master' spreadsheets, by running a macro in 3 different Access databases, each of which has links to the tables.

WTF.

WHAT THE ****.

Dear Actuaries everywhere if for SOME GOD D%$& reason, you get the urge to split your spreadsheet into 10 files, then DO NOT USE ACCESS to communicate between files.

Okay?

LEARN VBA.

Or better yet, learn Excel.
__________________
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.
Reply With Quote
  #19  
Old 05-16-2017, 04:04 PM
Ron Weasley's Avatar
Ron Weasley Ron Weasley is offline
Member
CAS AAA
 
Join Date: Oct 2001
Studying for naught.
Favorite beer: Butterbeer
Posts: 8,523
Default

Quote:
Originally Posted by Sredni Vashtar View Post
*@#$ Access!

I just inherited 3 sets of 10 spreadsheets that communicate to 3 'master' spreadsheets, by running a macro in 3 different Access databases, each of which has links to the tables.

WTF.

WHAT THE ****.

Dear Actuaries everywhere if for SOME GOD D%$& reason, you get the urge to split your spreadsheet into 10 files, then DO NOT USE ACCESS to communicate between files.

Okay?

LEARN VBA.

Or better yet, learn Excel.
Or do the rest of us a favor and leave the industry.
__________________
“Fantasy is escapist, and that is its glory. If a soldier is imprisioned by the enemy, don't we consider it his duty to escape?. . .If we value the freedom of mind and soul, if we're partisans of liberty, then it's our plain duty to escape, and to take as many people with us as we can!”
― J.R.R. Tolkien
Reply With Quote
  #20  
Old 05-16-2017, 04:30 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 11,897
Default

refresh all
refresh all
refresh all
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 12:04 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.19948 seconds with 9 queries