Im just starting to work on a database that tracks account balances at the end of each month for a large number of customers. I need to be able to store the information for 24 months. I am realativily new to larger databases and this will be the first database I have designed to be used by other people and i want to design it to run efficently. Each month I will be getting multiple excel spreadsheets with account balances in them and I need to know how to set up my tables to allow access to the data efficiently.
Right now the only ways I can think of to do this is have a table for each account(impossible in my case due to the large number of accounts) or have a new table each month (also difficult due to the variety of different account types which may or may not have a act # identical to an act # in another account type)
Is there an easyier way to design this?
Thanks in advance for the help,
-sa