[mso] Re: Database or Spreadsheet :VSMail mx1
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 8 Jun 2004 15:08:03 -0400
<<Linda, I do take exception to your
statement that Access doesn't contain all of the built in functions that
Excel does. It does have many of them, and a number of others that Excel
doesn't have. >>
Where did I say Access "doesn't contain ALL of the built in functions Excel
does"? I said QUOTE financial formulas like PMT, etc ENDQUOTE
If Access has these, then that sounds like an ABC article to me, cuz I'm
sure I'm not alone in thinking Excel makes this easier and is better with
mathematics. If you can show me how access handles financial functions like
PMT and FV, etc....then you will have one heck of an article there...cuz I
sure can't figure out how to do that in Access without understanding the
math behind it.
To be clear...I did NOT say Access can't do this....I said you would need to
understand the math behind it in order to do it, whereas in Excel, you can
just plug in the numbers into Excel's Paste Function box and Excel builds it
for you...When I use Access's Expression Builder, I need to know what to
multiply by what or I'm lost...with Excel, I don't need to know this.
I am NOT saying either program is BETTER....I'm saying they both have a
purpose and it's always best to use the right tool for the job. If you
believe Access does a better job at financial functions, then PLEASE share
that info cuz I'd LOVE to learn it! And, I'm not being sarcastic...if
Access has financial functions, I really WOULD love to know where they are
and how to use them.
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
ABC Free Ezine ~ Free Ebooks and Tutorials
*all outgoing mail scanned by Norton AV. If you got a bug that looks like
it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Tuesday, June 08, 2004 11:27 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Database or Spreadsheet :VSMail mx1
Linda,
Speaking as someone who learned Excel first and then Access, I can say that
both are very good at certain things. Linda, I do take exception to your
statement that Access doesn't contain all of the built in functions that
Excel does. It does have many of them, and a number of others that Excel
doesn't have. As for the built-in functions, sometimes they can actually be
worse than having the ready ability to create your own. Case in point, the
year 2000 and many of the financial calculations. In Excel, all financial
calculations are based on a 365 day year, unless its a leapyear. Excel did
not handle the year 2000 very well as it was the exception to the exception.
Attempting to use the Excel calculations threw off many calculations. I was
able to write my own equivalents in Access that came up with the correct
figures in the long run.
While I will readily admit that there are good uses for Excel, Access also
does. I will agree with you on Excel being easier to use and more
intuitive. Access is definitely a bear to learn, but once learned can be a
very powerful tool.
James
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
