Get the most out of your Office 2013 suite. Have a need for some metrics and can no longer get them from Access 2013 alone, well simply work Excel into the picture. I found myself in the same situation. This is an Excel report based on data contained within Access 2013 could be MS SQL Server for that matter. With one selection (customer or whatever) and a click of a button you can update all charts and print. No need to select/reselect chart boundaries or cut and paste. This solution requires MS Office 2013. If you need a more robust back-end then youll need MS SQL Server 2012.
MS Office 2013 Excel 2013 Reporting Charts Access 2013 MS SQL Server 2012 Office Integration
My area of expertise is in data analysis and mining. I have worked in a Microsoft environment for the last 20 years. Spent about 10 years developing and another 10 managing an IT department. Prior to switching over to the Microsoft platform I developed in the IBM midrange arena.
Some of my more recent work has been data analysis and extraction for some of the big Pharma. These initiatives surrounded data integration between disparate systems. This area is well suited for off-site w...