[mso] Re: Database or Spreadsheet :VSMail mx3
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 8 Jun 2004 16:52:50 -0400
I know how to use the Expression Builder, James....but that still requires
that I know the MATH...I need to know what needs to be multiplied by what,
etc....with Excel, I do NOT need to know that...I just plug in the numbers
in the Insert Function box....where it says "Initial value" I put in the
amount I need to pay back, where it says "Interest Rate" I plug that in. I
don't have to know "well, I need to multiply this by this, then take a
percentage of this"...I just plug in the numbers the car dealer gives me and
Excel does the rest.
All I'm saying is, Excel is MADE for mathematical equations....Access is
MADE for databases and relationships....if I want to calculate what my car
payments will be, I'll use Excel....if I own a car dealership and want a
report of all of the payment amounts of everyone who ever bought a car from
me, based on their credit rating and where they live in the country, I'd use
Access.
Building a database every time you need to do some mathematical calculations
and reports would be SERIOUS overkill, in my opinion. No?
Anyway...I'm heading out the door now to teach a class....hope you all enjoy
the rest of this discussion....just keep it friendly :-)
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 4:37 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Database or Spreadsheet :VSMail mx3
Linda,
You can use the expression builder. It contains the same prompts as your
wizard. The only thing you do is enter field names (or values) instead of
cell references. While you need to do a little to get to it, (not a lot) it
isn't much different than the Excel wizard. One of the best things is, I
can add a column to my query window without affecting my formula. Depending
on whether or not you use absolute references in Excel, adding a column or
row, could cause problems.
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:
