Access will clearly be an overkill
For 10 years, when the band played every single day, there will be less than 3700 rows of data (a single perfomance a row in table). Excel can handle this and more easily, and you'll have less headaches.
Leave at top of your table some empty rows where you'll calculate statistics.
It'll be reasonable declare your data as table, so enter headers into header row (at least row 3), and try to avoid spaces/underscores. P.e.
PerformDate, Avenue, Seats, Sales, ...
(Keep all data for single performance in single row)
Select headers and couple of underlying rows, and define the selection as Table (from menu: Insert>Table, check 'My table has headers')
At top of the sheet (leave an empty row above the table), aligned with table headers, enter formulas for calculating your statistic - use SUBTOTAL() function to calculate min, max, count, sum, average etc. You can have them in single row, when for one parameter only one stat is needed, but it will be better to have a separate row for every stat type you'll use - and leave cell empty when given stat isn't needed for particular parameter.
Use Freeze Panes to keep table headers and statistics always visible.
Enter your data into table.
Now, whenever you set any autofilter combination on your table, the statisics above will calculate min, max, count, sum, average etc. for filtered data