Access or Excel?

  • Thread starter Thread starter Sue Dorsey
  • Start date Start date
S

Sue Dorsey

I would like to create a database with fields Saleperson;
Sales in Wyoming; Sales in Idaho; Total Sales. Total
Sales would be addition of SOW + SOI/2. Would it be
better to setting this up in Excel or can it be done in
Access? Any suggestions on how would be appreciated.
Thanks much!
 
Assuming you are not an expert Access user, if what you've laid out is all
you're doing then doing it in Excel is indicated.

Access would be the better tool for gathering and managing the sales
statistics over the long haul. If you have an interest in Access then stick
with it and you'll be able to deliver an application.

In the mean time, give it to them in Excel. ]:-)

hth--
-Larry-
 
statistics on the long term are also possible with use of pivot tables
and/or charts if it must be graphical (read managers like)

grtz
Larry Daugherty said:
Assuming you are not an expert Access user, if what you've laid out is all
you're doing then doing it in Excel is indicated.

Access would be the better tool for gathering and managing the sales
statistics over the long haul. If you have an interest in Access then stick
with it and you'll be able to deliver an application.

In the mean time, give it to them in Excel. ]:-)

hth--
-Larry-
--

Sue Dorsey said:
I would like to create a database with fields Saleperson;
Sales in Wyoming; Sales in Idaho; Total Sales. Total
Sales would be addition of SOW + SOI/2. Would it be
better to setting this up in Excel or can it be done in
Access? Any suggestions on how would be appreciated.
Thanks much!
Click to expand...
Click to expand...
 
-----Original Message-----
I would like to create a database with fields Saleperson;
Sales in Wyoming; Sales in Idaho; Total Sales. Total
Sales would be addition of SOW + SOI/2. Would it be
better to setting this up in Excel or can it be done in
Access? Any suggestions on how would be appreciated.
Thanks much!
.
===
Click to expand...
I think it would be better,easy and faster if you create
it using Excel
One field called Salesperson
second field called region and the third would be total of
sales of both regions.

Good luck!
 
Thats some interesting accounting there...
Total sales = SOW + SOI /2 ?
Did you work for Enron previously? just kidding! :)

Based on the very limited info - I'd say Excel.

HS
 
Back
Top