Greetings,
I'm exploring the possibility of creating an Access DB that would serve as a place to upload and analyze monthly reports from various sources. Currently, I am using an Excel Spreadsheet that does what I want, but there is a lot of legwork involved when the once-a-month reporting period comes around.
In Excel, most of the time I delete the old data from last month and paste brand new data from the current month and analyze only that.
My question is, can I create an Access DB where I upload the reports that I run every month, but instead of trashing the old data, I stack it month after month after month and analyze how it changes over time?
With regards to the data I'm pulling, it's mostly human resources type stuff, so lots of names and dates that don't really change month to month. So, with that, my assumption is I would have to have some mechanism in my database to recognize each record's place in time (or when each record was uploaded) so that (1) the most current data is displayed on my reports and (2) I have a benchmark to analyze trends.
Apologies in advance if this is not enough to work with, but I appreciate any advice regarding this.