I am working on designing a database that will take usage statistics from numerous resources (normally counted once per month) and combine them into some sort of usable format for my co-workers (and boss!!). This is a huge project, involving statistics from approximately 100 different places. So far, however, I have been unable to think of the simplest way to design this database, since simply putting all the data in one table would not work due to the size.
In my most recent attempt, I created a table for each resource and then put all of the statistics for each in that table. But, I've been unsuccessfully trying to display these stats in a combination ever since. I think what's hanging me up is relating the tables so that they will display properly in queries and forms. I've tried having one table with a list of all the resources and then linking that to each database, but that still isn't giving me what I want.
The sort of display I have pictured in my head would look something like this:
(User wants data for the month of June 2006)
Resource Times Used Date
Resource A 15 June 2006
Resource B 22 June 2006
Resource C 12 June 2006
Anyone got any ideas? Feel free to ask questions if I haven't been descriptive enough.
(And for the record, I have only created sample tables so far--no huge amount of data entry has been done!)