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
  #21  
Old 05-17-2017, 09:30 AM
AndrewC's Avatar
AndrewC AndrewC is offline
Member
 
Join Date: Aug 2010
Posts: 945
Default

You may want to try SQL Server Express edition and Visual Studio Community; they are both free to download and use. I think they are far superior to MS Access.

https://www.microsoft.com/en-us/sql-...itions-express

https://www.visualstudio.com/vs/visual-studio-express/

Especially if you would like to use R / Phyton, Microsoft provides Visual Studio tools for these 2 programming languages.

https://www.visualstudio.com/vs/rtvs/

https://www.visualstudio.com/vs/python/
__________________
AC.
Reply With Quote
  #22  
Old 05-17-2017, 10:49 AM
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,246
Default

To the OP:
Sometimes one inherits a process so badly flawed that it becomes necessary to start over. Begin by figuring out what input is needed, what gets done to it, and what the resulting report needs to show. You may want to do this on your own, and present the result as a done deal, or (depending on your own situation) you might want to talk to your boss about why this needs to be done.
Either way, good luck!
__________________
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 Sep 18, 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.
MORE:
Quote:
Originally Posted by Dr T Non-Fan View Post
It would be rude to turn them down rudely. Try not to do that.
Quote:
Originally Posted by Woodrow View Post
Complementing your technical skills with social skills - whatever they are - will help your career. This is not a sign that the world is unjust.
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
  #23  
Old 05-22-2017, 02:14 PM
snakeroberts snakeroberts is offline
Member
Non-Actuary
 
Join Date: Jul 2016
College: k
Posts: 378
Default

Quote:
Originally Posted by JMO View Post
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.
if your lazy like me the easiest way is to link to tables in SQL from access then create via query design view, then paste the SQL into a pass through and change to TSQL with find and replace. Very little typing needed.

access is the best front end tool, easy to program, and little typing needed.
You just have to be smart about its limits.
Reply With Quote
  #24  
Old 05-22-2017, 04:43 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,327
Blog Entries: 1
Default

AH eff me, I came up with a brilliant janky workaround only it's failing at the last minute and people are going to be pissed at me for no g_d d__n reason.

Because, Access is deciding that "SELECT * , 0 FROM" means that I want the 0 before the *.
No Access, I put the zero after the * for a reason. AHHHH.

Meanwhile it's great fun trying to edit 10 simultaneous workbooks that are not only password protected but automatically lock up after every edit. I feel like God is playing a dumb game with me.

Quote:
Originally Posted by snakeroberts View Post
if your lazy like me the easiest way is to link to tables in SQL from access then create via query design view, then paste the SQL into a pass through and change to TSQL with find and replace. Very little typing needed.

access is the best front end tool, easy to program, and little typing needed.
You just have to be smart about its limits.
WTF WTF don't you dare use access for anything.
__________________
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.

Last edited by Sredni Vashtar; 05-22-2017 at 04:57 PM..
Reply With Quote
  #25  
Old 05-22-2017, 06:40 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,246
Default

Quote:
Originally Posted by Sredni Vashtar View Post
AH eff me, I came up with a brilliant janky workaround only it's failing at the last minute and people are going to be pissed at me for no g_d d__n reason.
You are the messenger with the bad news. In the real world that is the usual reason.

Quote:
<snip quote>
WTF WTF don't you dare use access for anything.
When used correctly, Access can indeed be a helpful tool. Just because you are stuck with a mess from somebody who used it incorrectly is NOT the fault of Access. (OK, Access does have its faults, but idiot users does not belong on their list.)

Good luck at getting this straightened out. I agree that an inherited mess is a horrible pain in the you know where.
__________________
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 Sep 18, 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.
MORE:
Quote:
Originally Posted by Dr T Non-Fan View Post
It would be rude to turn them down rudely. Try not to do that.
Quote:
Originally Posted by Woodrow View Post
Complementing your technical skills with social skills - whatever they are - will help your career. This is not a sign that the world is unjust.
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
  #26  
Old 05-22-2017, 06:41 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,246
Default

PS - can you remove the password protection?
__________________
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 Sep 18, 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.
MORE:
Quote:
Originally Posted by Dr T Non-Fan View Post
It would be rude to turn them down rudely. Try not to do that.
Quote:
Originally Posted by Woodrow View Post
Complementing your technical skills with social skills - whatever they are - will help your career. This is not a sign that the world is unjust.
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
  #27  
Old 05-23-2017, 07:13 AM
nonlnear nonlnear is offline
Member
Non-Actuary
 
Join Date: May 2010
Favorite beer: Civil Society Fresh IPA
Posts: 27,136
Default

Quote:
Originally Posted by snakeroberts View Post
if your lazy like me the easiest way is to link to tables in SQL from access then create via query design view, then paste the SQL into a pass through and change to TSQL with find and replace. Very little typing needed.

access is the best front end tool, easy to program, and little typing needed.
You just have to be smart about its limits.
People who need a GUI to create a simple query have no business making queries. When you understand what a query actually does, the GUI adds no more value.

At best Design View is a so-so teaching tool. But there are so many (non-advanced) things you can't do in Design View it's even of questionable value even for teaching the basics.

i.e. Anyone who is cognizant of its limits has no reason to use it.
Reply With Quote
  #28  
Old 05-23-2017, 07:58 AM
clarinetist clarinetist is offline
Member
Non-Actuary
 
Join Date: Aug 2011
Studying for Rcpp, Git
Posts: 6,728
Default

See my signature.

Anyone who uses 6,000,000 rows x 12 columns tables in Access and expects it to work with a huge MakeTable query requiring 20 JOINs is... well, I'll leave coming up those words as an exercise to the reader.
__________________
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
  #29  
Old 05-23-2017, 08:06 AM
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,246
Default

Quote:
Originally Posted by nonlnear View Post
i.e. Anyone who is cognizant of its limits has no reason to use it.
Unless, of course, in the real world it is the standard tool used by your employer.

It's not that I want to defend Microsoft, it's that it seems counterproductive to blame the tool as this thread (starting with the title) keeps doing.
__________________
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 Sep 18, 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.
MORE:
Quote:
Originally Posted by Dr T Non-Fan View Post
It would be rude to turn them down rudely. Try not to do that.
Quote:
Originally Posted by Woodrow View Post
Complementing your technical skills with social skills - whatever they are - will help your career. This is not a sign that the world is unjust.
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
  #30  
Old 05-23-2017, 08:23 AM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Member
 
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 4,327
Blog Entries: 1
Default

Quote:
Originally Posted by JMO View Post
PS - can you remove the password protection?
It's not mine to remove. I can certainly hack around it though...

Yeah, the situation is not really that bleak. It's just that this is a very small temporary part of a part-time job. So while the previous guy took weeks building this up, I have like an afternoon maybe to fix it.

I'd love to build it from scratch in a better environment, but instead I'm just going to compound his mess.

Good luck next person.
__________________
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.

Last edited by Sredni Vashtar; 05-23-2017 at 08:36 AM..
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 01:40 AM.


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.47443 seconds with 9 queries