Hi All,
I have been using Access for a few months now primarily as a raw data storage tool to house monthly snapshots of a loan portfolio, simply because it's been more efficient at storing the data than individual spreadsheets. I have 12 tables, each representing a snapshot of the loans and their balances at month's end. There are no established relationships between any of the tables or their records. Each row has around 25 data points, consisting of Customer info (name, address, DOB, etc), Loan characteristics (type, status, term, rate) and Loan-specific info (original date and balance, current balance, credit score @ open). My biggest issue is that I do not know to design (even conceptually) a database that will allow me to track a loan or a pool of loans overtime. At the very least I'd like to be able to create a query to see all monthly balances by loan type over the last 12 months.
I apologize if I haven't been very descriptive, but i'll do my best to clarify if needed.
Thanks