I need to revise my company's monthly sales reporting process. We currently
use an Excel spreadsheet, but it was created four years ago and lacks some of
the functionality I'd like.

I'm either going to start with a clean sheet and create a new Excel report
or set up a 'sales tracking database' in Access. I'm a novice Access user,
although I do have the manual and understand the basic concepts.

My company has almost 300 store locations and each will have its monthly
sales figures recorded in this report. In addition, each location pays
royalties based on a percentage of the sales figure. The percentage isn't
the same for all stores.

Reporting from this data is critical (and why I am uncertain which program
is the best solution). I need to see the data by month, by month with
year-to-date figures, percentage increases/decreases compared to previous
months, etc. I also need to see the data sorted in BOTH alphabetical order
and store number order (two separate sheets in Excel was my plan to
accomplish that).

So....is a new Excel workbook the way to go? 300 lines down and 13 across
for months and totals. Or would Access provide me more reporting
flexibility and store information long-term for future comparisons?

Thanks in advance for your input!