You can email me if you would like an Access Database.
The Specifications have been provided in a question to the Experts Exchange Community.
This approach combines the concepts of Bill Inmon and Ralph Kimball.
Inmon's view is that a Data Warehouse as simply a repository for all the data you are interested in.
Kimball's view is that you define separate Data Marts for specific functional areas, such as Sales, HR and so on.
In my experience, which dates back over 15 years, Data Marts are more likely to be successful because they usually ahve a clear deadline for delivery and a group of users eagerly waiting.
Data Warehouses, on the other hand, used to be based on the concept of 'Let;s put all our data in one big basket and people can come and help themselves".
The problem is that they could, but they didn't, for a variety of reasons.
Therefore a Data Warehouse was more likely to fail than a Data Mart.
Click here for a discussion of Kimball v Inmon.
For Commercial Data Warehouses, there are four dimensions that usually appear, which are Customer, Date, Location and Product and
A Data Warehouse has been created showing these.
February 22nd. 2011
Database Answers Ltd.