Access 2010 - Data analysis assistance
Posted on 2015-02-11
I am looking for some advice or links to relevant articles/tutorials on the following concept.
Basically I'd have a spreadsheet from Excel that has information on accounts/records. Think Clients.
After importing that to Access, the next day, there would be changes to the aforementioned Excel workbook. Items like, whether an account has been "opened" or "closed" or put "on hold", etc.
So, I'd import that into Access, and my goal here would be to try and compare the previous import to the next day's import, as to be able to generate a report, or give some indication, of what all has taken place, such as which clients were closed or put on hold. Perhaps what costs have increased for clients (i.e. yesterday there would be a $50 balance, the next day there'd be a $20 balance).
So things like that. Is Access suitable? What could be done to at least put me on the right path?
I've checked with an Excel expert, but they advised there's just too much data for vlookups to work with, and it's somewhat tedious.
I'm new to Access