Guerrilla Data Analysis using Pivot Charts in Microsoft Access 2007

MS Access 2007 logo
Until last Friday, it had been almost a full decade since I last launched a copy of Microsoft Access. I spent a fair amount of my undergraduate career getting familiar with it and the concepts of relational databases, and SQL, but once I started working with full-featured database servers like Oracle and Microsoft SQL Server, Access just looked like a cute little toy piece of software that I had simply outgrown.

But thanks to the need for some quick and dirty data analysis at work last week, I have a new respect for Access 2007 and one of its coolest features: The Pivot Chart.

(more…)

Continue Reading
Close Menu