learning MS Query

[countingapples]

Does anyone have a suggestion for learning MS Query? I need to learn it so that I can effectively use and manage a large number of queries in Excel. I already have a few SQL books to look into so that I can learn that as well.

 

[SydneyGeek]

The best resource that I've come across is Excel Advanced Report Development (Timothy Zapawa, Wiley)

Denis

 

[countingapples]

Thanks! I'll see about acquiring a copy on Saturday.

 

[Richard Schollar]

The best resource that I've come across is Excel Advanced Report Development (Timothy Zapawa, Wiley)

Agreed. Truly excellent section (appendix) on writing SQL. Deals a lot with MSQuery, unlike virtually every other book on Excel which I have where MSQuery barely seems to warrant a mention.

One thing I will say, I notice there's the second edition of the book about to be released (according to Amazon) - it may be worth waiting to either pick up the new edition or getting the existing one at a knock-down price. I think the book is well worth the cover price though.

 

[countingapples]

I've ordered the book recommended. The new edition won't be available until March of 2007, so it'll be the first edition. I also picked up a book on SQL since so much of what I inherited with this job was done with SQL in addition to the MS Query.

Thanks for the suggestions.