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

DW Simpson International Actuarial Jobs
Canada  Asia  Australia  Bermuda  Latin America  Europe

Thread Tools Display Modes
Old 05-17-2017, 09:30 AM
AndrewC's Avatar
AndrewC AndrewC is offline
Join Date: Aug 2010
Posts: 945

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.

Especially if you would like to use R / Phyton, Microsoft provides Visual Studio tools for these 2 programming languages.
Reply With Quote
Old 05-17-2017, 10:49 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 35,608

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 Mar 15, 2017.

I should keep these two permanently.
Originally Posted by rekrap View Post
JMO is right
Originally Posted by campbell View Post
I agree with JMO.
Originally Posted by whisper View Post
It is really easy to judge from an ill-informed, outside view.
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:
Originally Posted by JasonScandopolous View Post
To which I say: duh and lol.
Originally Posted by Colonel Smoothie View Post
actuarial isn't the only good career out there.
All round good advice:
Originally Posted by snikelfritz View Post
Don't live your life by other people's expectations.
Reply With Quote
Old Today, 02:14 PM
snakeroberts snakeroberts is offline
Join Date: Jul 2016
College: k
Posts: 293

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

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 03:08 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.24510 seconds with 9 queries