Microsoft Access has the steepest learning curve of all the Microsoft Office applications. Its basic functions aren't really intuitive, and users typically need to do some programming as part of their first Access project. For those reasons, Access is the Office application for which Office users--even experienced, highly competent ones--tend to need help learning.
Alison Balter's Mastering Microsoft Access 2003 is a new addition to the shelf of Access manuals, and it's one of the best. Balter does a great job of helping a novice Access user (someone who can open a database and edit fields, but can do little more) become an accomplished user. In other words, this book teaches Visual Basic for Applications (VBA) programming as it applies to Access. The word "Mastering" is appropriate in its title.
Balter's basic approach is to introduce a concept (say, the Implements keyword or ADO Database objects) and quickly explain its purpose with prose, then provide an example of how the concept works in practice. Which is to say, she provides a code sample. Because of this strategy, almost every page of this book has code on it. However, the author appears to have made a conscious effort to keep her code snippets short and easily comprehensible. Long, difficult-to-trace listings that span multiple pages are thankfully absent. Balter also does a good job of illustrating the Access development environment, including many screen shots of Access at work and of the applications that result from her code. This is a detailed, carefully considered book that will make sense to all but the most inexperienced Access users. --David Wall
Topics covered: How to write applications with Microsoft Access 2003. Noteworthy coverage deals with the Access way of handling object orientation, clever form-design strategies, and scores of techniques for performing various procedures on databases. Security coverage is good, too.
Alison Balter is the president of InfoTechnology Partners, Inc., a computer consulting firm based in the rural Santa Rosa Valley Area, close to Camarillo, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 19 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTechnology Partners, Inc. (formerly Marina Consulting Group) in 1990, its client base has expanded to include major corporations and government agencies such as Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others.
InfoTechnology Partners, Inc., is a Microsoft Certified Partner, and Alison is a Microsoft Certified Professional. Alison was one of the first professionals in the computer industry to become a Microsoft Certified Solutions Developer.
Alison is a partner in the multimedia training company Blast Through Learning, Inc., and is the author of more than 300 internationally marketed computer training videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, and 15 Access 2003 videos. These videos and CD-ROMs are available by contacting Alison's company, InfoTechnology Partners, Inc. Alison travels throughout North America, giving training seminars on Microsoft Access, Visual Studio .NET, Microsoft SQL Server, Visual Basic, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.
Alison is a regular contributing columnist for Access/Office/VB Advisor as well as other computer publications. She is also a regular on the Access, Visual Studio .NET, SQL Server, and Visual Basic national speaker circuits. She was one of four speakers on the Visual Basic 4.0 and 5.0 World Tours seminar series co-sponsored by Application Developers Training Company and Microsoft.
Alison is also the author of six other books published by Sams Publishing: Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, and Learning Office Access 2003 in 24 Hours. Alison is a coauthor of three Access books published by Sams Publishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed.
An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users' Group.
On a personal note, Alison keeps herself busy horseback riding, skiing, ice skating, running, lifting weights, hiking, traveling, and dancing. She most enjoys spending time with her husband, Dan, their daughter, Alexis, their son, Brendan, and their golden retriever, Brandy.
Alison's firm, InfoTechnology Partners, Inc., is available for consulting work and on-site training in Microsoft Access, Visual Studio .NET, Visual Basic, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows 98, Windows XP, PC networking, and Microsoft Exchange Server. You can contact Alison by email at Alison@InfoTechnologyPartners.com, or visit the InfoTechnology Partners Web site at http://www.InfoTechnologyPartners.com.