Looking for some advice prior starting any changes. I have a massive database with Customer complaints, injuries, etc. Pretty simplistic and includes incident location. I generate reports monthly that go to each location's manager. It's really just two graphs. Incident totals by month (bar graph) and a types of incidents (pie chart). I currently do it in excel. I have the database linked, which then flows into pivot tables, ands then flows into charts. I then export those charts into Powerpoint. It's time-consuming though because we have roughly 30 locations and copy / pasting these 60~ charts into 30 powerpoint files takes some time.
Utilizing Reports within Access, is this something that could be automated? Like having 30 different reports on the database that are just updating regularly? Any thoughts are helpful. Thank you!