What is the next database upgrade after MS Access cannot handle the amount of data you have to process?

I have 1M+ records I need to be able to quickly manipulate and group for analysis. Looking for recommendations for a light weight tool as the team I manage are somewhat technically savvy but at the end of the day are more finance professionals than IT professionals.