Please Note: This site’s design is only visible in a graphical browser that supports web standards, but its content is accessible to any browser or Internet device.

Book Reviews

The following books may be useful as further reading. No endorsement of these sites or products is implied.

Scott Mueller’s Upgrading and Repairing PCs - 18th edition

Publisher - Que

Author - Scott Mueller

This guide to upgrading and repairing PCs provides technical illustrations and photos to help step the reader through the building and/or upgrading process. This edition includes coverage of new Core 2 processors from Intel, Socket AM2 processors from AMD, significant advances in motherboard chipsets, Blu-Ray and HD-DVD. The CD includes 90 minutes of how-to videos. It’s a MUST HAVE book for everyone that wants to know more of what is a PC, what technologies are and what will be around in the near future!

Excel Formulas

Excel 2003 Formulas

Publisher - Hungry Minds

Author - John Walkenbach

This book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools. It helps the reader master basic formula facts, including absolute vs. relative references, operators, error values, naming techniques, and more. It offers practical tips on using Excel's worksheet functions in formulas, using formulas to enhance charts and pivot tables, developing custom worksheet functions with VBA, using powerful array formulas, and debugging.

Visual Basic 2005 Programmers Reference

Publisher - John Wiley & Sons

Author - Rod Stephens

Visual Basic 2005 adds new features to Visual Basic that make it a more powerful programming language than ever before. This combined tutorial and reference describes VB 2005 from scratch, while also offering in-depth content for more advanced developers. Whether you're looking to learn the latest features of VB 2005 or you want a refresher of easily forgotten details, this book is an ideal resource.

Visual Studio 2005 Tools for Office for Mere Mortals

Publisher - Addison Wesley

Author - Kathleen McGrath and Paul Stubbs

This is for VBA developers who are interested in migrating their skills to the next generation of Office development. Learn all about writing managed code applications with Word 2003, Excel 2003, and Outlook 2003, as well as creating add-ins for the most popular applications in Office 2003 and the 2007 Microsoft Office System. See how to secure and deploy solutions created with VSTO and VSTO 2005 SE.

Office 2003 Programming: Real-World Examples

Publisher - Apress

Author - Ty Anderson

This book is all about a set of independent real-world VB-oriented business applications that utilize, customize, and extend the Microsoft Office applications.

Excel 2007 VBA

Publisher - John Wiley & Sons

Authors - John Green, Stephen Bullen, Rob Bovey and Michael Alexander

This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users.

Professional Access 2000 Programming

Access 2003 VBA Programmer's Reference

Publisher - John Wiley & Sons

Author - Patricia Cardoza, et al

Access 2003 VBA Programmer's Reference provides comprehensive coverage of the use of VBA for building Access applications. The typical reader would be expected to have some experience with VBA programming or attended our training courses. (Note that this book covers both Access 2002 and Access 2003.)

Professional Access 2000 Programming

Professional Access 2000 Programming

Publisher - John Wiley & Sons

Author - Felipe martins, et al

This book addresses the needs of the intermediate to higher level Access programmer, while providing real-world tutorials and case studies that give a practical guide to building professional quality custom database applications. Practically everything you will ever want to know about programming Access 2000.

Access 2000 Developer's Handbook Set V1 & V2

Access 2000 Developer’s Handbook Set V1 & V2

Publisher - Sybex International

Author - Paul Litwin, Ken getz, Mike Gilbert

Written for Access 2000 developers, this set consists of two volumes which deliver expanded coverage on the most challenging topics. Included are two CDs which contain sample code from both books, ready to be modified or reused as is.

Access 2002 VBA Step by Step

Access 2002 VBA Step by Step

Publisher - Microsoft Press

Author - Evan Callahan

Teach yourself just what you need to know about developing add-ins for Microsoft Office XP. This title, aimed at beginner developers, is a teach-yourself guide to creating custom software solutions, automating tasks, and taking creative control of Access Version 2002 by exploiting VBA.

Advanced Modelling in Finance

Advanced Modelling in Finance Using Excel and VBA

Publisher - John Wiley & Sons Inc

Author - Mary Jackson and Mike Staunton

This unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. It takes a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. Each area contains both standard material and more advanced topics.

Excel 2002 Power Programing with VBA

Excel 2002 Power Programing with VBA

Publisher - John Wiley & Sons Inc

Author - John Walkenbach

This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively.

Outlook 2000 VBA

Outlook 2000 VBA Programmer’s Reference

Publisher - John Wiley & Sons

Author - Dwayne Gifford

Outlook 2000 is an important part of the Office 2000 program suite. Outlook 2000 now hosts VBA (Visual Basic for Applications) and hence there is a strong emphasis on between-application automation, Using VBA, the user can program his or her own programmes in what is a subset of the Visual Basic programming languages. This book presents a full reference to the Outlook object model - which is essentially the object-oriented system of organizing the functional capacities that make up the Outlook program. It features a short introduction to VBA itself, and the rest of the book documents aspects of programming Outlook through that object model. The book is divided into three broad sections: the first part introduces Outlook and VBA; the second offers thematic discussions of the workings of the Outlook 2000. The third and final part offers a full reference to the Outlook object model.