Convert Microsoft Access Database to Pivot Tables/Charts

I have a large database of data. Each month I run a query. From this query I produce around 30 pivot tables from this raw data. I also produce 3-4 cumulative charts. All these get put in to one excel file and sent to clients.

I would like to be able to automatically run the query and have the charts and pivot tables automatically update. That way I dont need to create the pivot tables and charts each time. If you think you can help, let me know how you think the best way to go about it is.

Skills: Microsoft Access

See more: how to microsoft excel, pivot tables, excel PIVOT, need access database help, excel convert access, excel file convert, access query excel, convert raw data excel, access create query, excel convert raw data, convert excel file database file, excel database update, excel convert pivot data, excel create access database, excel raw data convert, access database excel, access database data month, convert database excel, convert raw data pivot excel, excel pivot database, excel database query, pivot access, convert pivot raw data, create access database clients, convert excel raw data

About the Employer:
( 11 reviews ) Wagga Wagga, Australia

Project ID: #6748196

1 freelancer is bidding on average $30 for this job


I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Proje More

$30 AUD in 1 day
(67 Reviews)