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


Upload your resume securely at https://www.dwsimpson.com
to be contacted when our jobs meet your skills and objectives.


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: 35,909
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 July 21, 2017.

Spoiler:
I should keep these three 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.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
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: 345
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,023
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: 35,909
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 July 21, 2017.

Spoiler:
I should keep these three 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.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
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: 35,909
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 July 21, 2017.

Spoiler:
I should keep these three 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.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
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: 26,684
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,703
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: 35,909
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 July 21, 2017.

Spoiler:
I should keep these three 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.
MORE:
Quote:
Originally Posted by Locrian View Post
I'm disappointed I don't get to do both.
Quote:
Originally Posted by PeppermintPatty View Post
It's SO much better to work for a good manager.
Quote:
Originally Posted by Patience View Post
slow down
Quote:
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
Quote:
Originally Posted by Colonel Smoothie View Post
The ones who complain that they're too good for that kind of work really aren't that good.
Two really useful all-purpose responses. Use one or both:
Quote:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Careers:
Quote:
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
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,023
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 06:42 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.46816 seconds with 9 queries