???Use Excel or Access

[Jaylin]

I have an Excel Table

Budget_ID Desc_Activity Source_Country Sub_Category January
BA/08/AS/60349 Promotion AMERICAN SAMOA Print Development 291.67
BA/08/AS/60349 TV AMERICAN SAMOA Radio Production 125
BA/08/S3/24530 TV APAC CB Consumer Database 0
BA/08/S3/68144 Promotion APAC CB Core Agency Fees 50000
BA/08/S3/99775 Promotion APAC CB Other Development 0
BA/08/S3/85873 Promotion APAC CB Working Media - Internet 12500
BA/08/AU/19023 Promotion Australia Print and POS 0
BA/08/AU/95848 Promotion Australia Core Agency Fees 23492

 

[Pete D.]

Yes you can.

Now if your question is which would be better we could use a little more
info. Will you continue to add records/rows of data or will you just change
some each month to do math on it. Access is to store data, Excel is to
calculate data. You can store data in Access and then calculate that data
in Excel or Access. Question is kind of like asking, do I use Excel or a
Calculator. Depends on if you're going to do it once or many times and how
complicated the formulas will be whether it is worth the time to put it in
Excel. Looking at your sample data there would be some efficiency to using
Access, for one you wouldn't have to type American Samoa or Promotion over
and over in a properly normalized data file. Take a look at below link for
more thoughts.

http://office.microsoft.com/en-us/help/HA010429181033.aspx