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


Fill in a brief DW Simpson Registration Form
to be contacted when new jobs meet your criteria.


Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 03-30-2010, 08:15 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: 37,643
Default

Quote:
Originally Posted by ADoubleDot View Post
Yeah, my bad. First pivot tables, then world conquest.



Uh, 2 years of experience guy says - what's a normalized data structure?
http://www.agiledata.org/essays/dataNormalization.html

Quote:
Data normalization is a process in which data attributes within a data model are organized to increase the cohesion of entity types. In other words, the goal of data normalization is to reduce and even eliminate data redundancy, an important consideration for application developers because it is incredibly difficult to stores objects in a relational database that maintains the same information in several places.
__________________
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 Nov. 20, 2018.

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:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #12  
Old 03-30-2010, 08:17 AM
ADoubleDot's Avatar
ADoubleDot ADoubleDot is offline
Member
SOA
 
Join Date: Nov 2007
Location: Slightly Dusty South
Studying for the rest of my life
Posts: 37,153
Default

Oh, seems like common sense.
__________________
ADoubleDot: I'm an actuarial icon.

**** Juan.
Reply With Quote
  #13  
Old 03-30-2010, 08:52 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: 37,643
Default

Quote:
Originally Posted by ADoubleDot View Post
Oh, seems like common sense.
You'd be surprised by how many data bases violate that principle. sigh
(Or maybe you wouldn't.)
__________________
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 Nov. 20, 2018.

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:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #14  
Old 03-30-2010, 09:51 AM
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,623
Default

Quote:
Originally Posted by JMO View Post
You'd be surprised by how many data bases violate that principle. sigh
(Or maybe you wouldn't.)
Only the stuff implemented prior to the mid 90's, or stuff built on top of stuff implemented prior to the mid 90's, or stuff meant to work with stuff that was built on top of stuff implemented prior to the mid 90's. Also, there's all of the adhoc stuff built by folks accustomed to working with stuff built in the style of prior to the mid 90's.

The remaining 0.2% seems to be okay.
Reply With Quote
  #15  
Old 03-30-2010, 10:24 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: 37,643
Default

Quote:
there's all of the adhoc stuff
built by the BFBI* methodology. The people using this may or may not have been around in the 90's.

*Brute force and bloody ignorance.
__________________
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 Nov. 20, 2018.

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:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #16  
Old 03-30-2010, 11:07 AM
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,623
Default

Quote:
Originally Posted by JMO View Post
The people using this may or may not have been around in the 90's.
Very true, but they're often trained in an environment that hasn't moved on.
Reply With Quote
  #17  
Old 03-30-2010, 11:16 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: 37,643
Default

Quote:
Originally Posted by Ron Weasley View Post
Very true, but they're often trained in an environment that hasn't moved on.
In my experience, there isn't any actual "training." That's why BFBI is so often adopted.
__________________
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 Nov. 20, 2018.

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:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by El Actuario View Post
Therapists should ask the right questions, not give the right answers.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #18  
Old 03-30-2010, 12:49 PM
Nobody22's Avatar
Nobody22 Nobody22 is offline
Member
 
Join Date: Oct 2008
Posts: 767
Default

Select Queries.
I would focus on simple select queries as these are mainly all that would be required since they serve to aggregate the data and you can utilize excel skills for the rest. Obviously this is not always ideal, but it will get the job done. Note that there is a query design feature in Access, and query wizard, which allow you to do these in a crude way.

Learning SQL will open up more complex functions and procedures, as some methods cannot be done any other way.
You can practice SQL here
__________________
VEEs | P FM MFE L C | CA1 CA2 | 5 6 | 7 8 9

Correlation doesn't imply causation, but it does waggle its eyebrows suggestively and gesture furtively while mouthing 'look over there'. - xkcd.com/552
Reply With Quote
  #19  
Old 03-30-2010, 01:59 PM
sticks1839 sticks1839 is offline
Member
CAS AAA
 
Join Date: Jul 2005
Posts: 1,649
Default

Quote:
Originally Posted by PSU2002 View Post
One key thing to know is that in access once you create a table that takes up space in your database, the database remains that size even if you delete the table. This makes thinking ahead a good practice. if you know that at some point you are going to have to add more columns to a table, add them now and leave them empty. Then do update queries to fill the fields. This eliminates the practice of making a new table every time you need to add a field, and it also eliminates the need to go into the table design and add the field manually to save space. Try to make it as automated as possible.
\Tools\Database Utilities\Compact and Repair

This is your friend when deleting information from Access tables. It will remove the unnecessary space from the database size.

In conjunction with this it is always better to create a table and define the variable sizes then use append/delete queries to fill/empty the table as opposed to using make-table queries because they tend to overestimate the variable type wasting memory.

Both of these are especially important for large databases in older versions of Access with the 2GB limit.
Reply With Quote
  #20  
Old 03-30-2010, 03:04 PM
carryme's Avatar
carryme carryme is offline
...:illllllli:..
 
Join Date: Feb 2005
Posts: 1,955
Default

Quote:
Originally Posted by JMO View Post
Whoa, everybody.

Before learning tricks to do with Access, I wish everyone would become familiar with normalized data structures, and think about how their data is going to be USED in Access. JMO of course.


First things first.

Understand what a database is; what relational database means. Know database entities: tables, fields (columns), records (rows), queries, joins, etc.

Then focus on what MS Access has to offer in particular.
__________________
...:illlllllli:...
Reply With Quote
Reply

Tags
access, computer skills, microsoft, vba

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 10:18 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.32643 seconds with 11 queries