Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
Excel Advanced Report Development Review by Niels C. Burmester
You need to have SQL Server to do all of the examples
This is an excellent book. I would give it 5 stars, but the author chose to use SQL Server for the SQL query examples when it would have been easier for most people to simply use Access.
There is a work around for this. The problem is that the author uses the CASE SQL command, which is not available in Access. All he is doing is reformating the data (0 and 1 become "available" or "unavailable"). Edit out the CASE command so that it just grabs the raw data.