Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® نسخه متنی

Further Reading

As we stated at the beginning of the chapter, the subjects covered here are all book-length topics in their own right. Therefore, we would be remiss if we didn't recommend some good books you could use to pursue the full breadth of these topics. The books recommended below have been found very useful by the authors of this book. We have no financial stake in any of them. These recommendations are based purely on quality.

Professional SQL Server 2000 Database Design

Authored by Louis Davidson

ISBN 1861004761 - Wrox

Although the title contains "SQL Server 2000," the first half of this book provides very detailed coverage of data normalization and relational database design in a software-agnostic manner. If the first section of this chapter was unclear or left you wanting more information, this is the book for you. Sadly, this book is now out of print, but used copies can be readily obtained through Amazon.com.

ADO 2.6 Programmer's Reference

Authored by David Sussman

ISBN 186100463X - Wrox

Professional ADO 2.5 Programming

Authored by David Sussman et al.

ISBN 1861002750 - Wrox

Unfortunately, there were not very many excellent books on "classic ADO" to begin with. Now that Microsoft has moved on to ADO.NET (a completely different technology regardless of the similar acronym) what few good books there were are going out of print very quickly. That applies to both of these titles, although again, you can readily find used copies through Amazon.com.

The ADO 2.6 Programmer's Reference is exactly what its title would suggest: a very comprehensive reference to the ADO object model. It is essentially a high-quality ADO dictionary. Professional ADO2.5 Programming assumes that you understand all the basic concepts of ADO and goes on to show you how to apply them in a series of advanced application scenarios.

Professional SQL Server 2000 Programming

Authored by Robert Vieira

ISBN 0764543792 - Wrox

If you want to learn about SQL Server, there is no better place to start than here. The best way to describe the scope of this book is that it starts where ADO ends. It is tightly focused on pure SQL Server topics. It provides excellent SQL Server-specific coverage of SQL, stored procedures, views, indexes, transactions, and the tools used to manage and program SQL Server, among many other topics.

Access 2002 Developer's Handbook Set

Authored by Paul Litwin, Ken Getz and Mike Gunderloy

ISBN 0782140114 - Sybex

This is the latest update of an ongoing series of first-class Access development books that began with Access 95. This book touches on all aspects of Access development, from running Access SQL directly against an Access database to developing reports in the Access user interface. If you want a comprehensive reference to Access development, this should be your first choice.