David Carter's tutorial uses a sample database enabling companies to learn how to improve their sales orders and stock control which runs through an accounts package written in Access by live-linking Excel direct to their Access database. His analysis also utilises pivot tables. This is an introduction to a series of four tutorials.
The fact is that companies are still reliant on Excel to run sales and forecasting. The finance director would love to pull all these elements of business technology together and make the system work for him.
