So... right now at my job I have 10 different outlook files for different sales people. Each file has the accounts they handle and the monthly revenue going back - 10 years.
The problem - is having to update 10 different files each month...
I would love to be able to use access to have every account in one place and then when I update those each excel sheet gets updated for the staff?
Is that easily doable in Access?
I consider myself a strong user of excel but have never used access..
Not to sound ungrateful for your continued presence on Neowin (which I prefer) 😛 But would you consider a subscription to just have all the third party ads turned off by us?
It's $28 ($2.33 per month) for the ad-free subscription, but it is also there for assistance and support with all the running costs.
Like everything, it is becoming increasingly harder to do this, we even try to offset it with Amazon affiliate commissions (if we could finance totally through that instead of ads, I would) 😛
Question
Sk8Surfr
So... right now at my job I have 10 different outlook files for different sales people. Each file has the accounts they handle and the monthly revenue going back - 10 years.
The problem - is having to update 10 different files each month...
I would love to be able to use access to have every account in one place and then when I update those each excel sheet gets updated for the staff?
Is that easily doable in Access?
I consider myself a strong user of excel but have never used access..
Thanks in advance!
Link to comment
https://www.neowin.net/forum/topic/1265462-using-access-over-excel-for-database-management/Share on other sites
12 answers to this question
Recommended Posts