Details

Introduction. <p>Chapter 1: Designing Applications.</p> <p>Chapter 2: Introduction to Event-Driven Programming.</p> <p>Chapter 3: Creating Code.</p> <p>Chapter 4: Controlling the Program.</p> <p>Chapter 5: Using Access Objects.</p> <p>Chapter 6: Using DAO.</p> <p>Chapter 7: Data Management Techniques.</p> <p>Chapter 8: Working with Tables.</p> <p>Chapter 9: External Data.</p> <p>Chapter 10: Reports.</p> <p>Chapter 11: Advanced Programming Techniques.</p> <p>Chapter 12: Finding and Dealing with Errors.</p> <p>Chapter 13: Using Classes.</p> <p>Chapter 14: WithEvents and RaiseEvent.</p> <p>Chapter 15: Libraries and Add-Ins.</p> <p>Chapter 16: Automation.</p> <p>Chapter 17: Multi-User.</p> <p>Chapter 18: The Internet.</p> <p>Chapter 19: Optimizing Your Application.</p> <p>Chapter 20: Moving to Client-Server.</p> <p>Chapter 21: ActiveX Data Objects – ADO.</p> <p>Index.</p>

<b>Robert Smith</b> has been developing solutions with Access for over 10 years, in fact, ever since its original launch in November 1992. He currently works for EH3 Consulting, a software consultancy with offices in Edinburgh and Bath, where most of his time is spent designing Access or SQL Server - based solutions for a variety of companies throughout the UK and Europe.<br /> When not working, Rob takes a keen interest in the progress (or otherwise) of Crystal Palace Football Club, as well as indulging his other passion for collecting (and occasionally sampling) fine wines. In practice, the varying fortunes of the former normally mean that he spends a lot more time sampling than collecting. <p><b>Dave Sussman</b> has spent the majority of his professional life as a developer, using both Unix and Microsoft-based products. After writing his first two books while in full time employment, he realized that being an author sounded more glamorous than being a programmer. The reality is somewhat different. He now spends most of his time writing books for Wrox Press, speaking at conferences, and playing with most be ta products that Microsoft ships.</p> <p><b>Ian Blackburn</b> is director of Blackburn IT Services Ltd (http://www.bbits.co.uk) – an IT firm based in Kent, UK, offering technical training, development, and consultancy. He has long experience in many areas including Microsoft Office development, ASP and ADO, SQL Server, Site Server, Visual InterDev, Visual Studio .NET, ASP.NET, and e-commerce. He is an MCSE and has been a MCP since 1993.</p> <p><b>John Colby</b> is an independent consultant who has specialized in Access development since 1994, designing databases for companies in the U.S., Canada, Mexico, and Ireland. John is past president and current board member of Database Advisors Inc., (www.databaseadvisors.com), a not-for-profit organization dedicated to providing fellow Access and Visual Basic developers with a place to discuss what we do, why we do it, what works, and what doesn't. Database Advisors Inc. also allows developers to showcase their talents by sharing databases, wizards, and various code packages.<br /> John lives in Connecticut with his family. He enjoys music, travel, and all things computers, and dreams of getting back to Europe someday soon.</p> <p><b>Mark Horner</b> is Senior Architect and Development Consultant with Torville Software, which specializes in decision support and web-centric knowledge systems. He has worked in a variety of roles with Australian, UK, and US corporations including: ANZ Banking Group, Aspect Computing, British Aerospace, Citibank, Hewlett Packard, and Tenix Defence Systems.<br /> Mark holds a bachelor of business degree from Swinburne University of Technology and an MBA from Monash University, Australia. He is a member of the Internet Society (www.isoc.org) and a Dilbert devotee (www.dilbert.com).<br /> <i>I would like to thank the Wrox team for their determination “to make the books that make the difference” and the engineers at Redmond for more great development tools. Special thanks to Sarah Bowers for getting me into technical reviewing and to Beckie Stones for getting me into writing.</i></p> <p><b>Martin W. P. Reid</b> is an Analyst at The Queen's University of Belfast. Martin has been working with Microsoft Access since version 1 and his main interest is working with Access Data Projects. He has contributed several articles to Smart Access, Inside SQL Server, and Inside Microsoft Access, and is a contributor to TechRepublic (www.techrepublic.com) and www.builder.com. He is also co-author of <i>SQL: Access to SQL Server</i>, published by Apress, and has been the technical editor on books involving technologies from VB.NET database programming to Oracle 9<i>i</i> PL/SQL and Macromedia Dreamweaver MX.</p> <p><b>Paul Turley</b>, his wife Sherri, and their four children live in the small community of Port Orchard, Washington, on the shores of the Puget Sound. He works for Netdesk, Corp in downtown Seattle as a Developer Instructor and Project Consultant. He began his IT career in 1988, installing and supporting medical billing systems and obtained his MCSD certification in 1996. Paul began using Access version 1.0, SQL Server 4.21, and Visual Basic 3.0. Since then, he has built custom database systems for several businesses including Hewlett-Packard, Nike, Microsoft, and Boise Cascade. He has worked with Microsoft Consulting Services on large scale, multi-tier solutions employing new Microsoft technologies. As an independent trainer/consultant, he traveled for Microsoft and various training providers to teach project design and management, application development, and database design.<br /> Paul currently maintains www.scout-master.com, a web-based service that enables Boy Scout units around the world to maintain their membership and advancement records on-line using ASP.NET and SQL Server. He has published course materials and has been a contributing author on books and articles, including <i>Professional Access 2000 Programming</i> and <i>SQL Server Data Warehousing with Analysis Services</i> from Wrox Press.</p> <p><b>Helmut Watson</b> started his IT career nearly twenty years ago writing games for the BBC micro. Soon after that he had to get a proper job so he moved into databases, initially using PC-Oracle v1.0. He quickly decided to change to DBMS that actually worked – Dbase, Clipper, Paradox, Informix, SQL Server, etc. After twenty years, there aren't many on the list left to try now.<br /> Helmut specializes in database analysis and GUI design and runs a consultancy called "Nearly Everything" from his home in Essex, UK.<br /> Known as Woof! to his friends (or anyone else who buys him a beer), he is a keen cyclist and a finalist in the 2000 British Marbles-on-Sand championships. Most people think he's a bit odd until they meet him – then they're sure!</p>

If you are using Access and want to go to the next level, you need to learn VBA. As part of Visual Basic®, VBA allows you to use some of the tremendously powerful programming techniques. In this book, we show you how VBA gives you complete control over the way your users view and interact with your Access databases. <p>This is the next level of Access skills, presented to you here in a clear tutorial style.</p> <p>This book is a revision of the best-selling "Beginning Access 97 VBA" and "Beginning Access 2000 VBA" books, reworked to provide a rich and comprehensive guide to programming Access 2002 with VBA.</p> <p>Who is this book for?</p> <p>This book is designed for people with experience using Access databases, who now want to learn how to program them with VBA. No prior knowledge of programming is needed.</p> <p>This book is also a useful reference and tutorial for those with some VBA experience or knowledge of other programming languages.</p> <p>In this book you will learn how to:</p> <ul> <li>Write your first VBA program – how to structure code, control programs, respond to events, and use objects</li> <li>Create powerful Access user interfaces</li> <li>Publish your data on the internet using the improved functionality of Access 2002</li> <li>Debug your programs, and increase their performance and usability with robust error handling</li> <li>Improve the performance and security of your database by using the SQL Server® Desktop Engine</li> <li>Access your data efficiently with SQL, DAO, and ADO</li> <li>Add support for multiple users and integrate with other Office XP™ applications</li> </ul> <p>"We picked up "Beginning Access 2000 VBA" because we needed to be productive quickly. This is the one book that will take you from playing with Access to programming in Access. This book became a favorite with those that had no programming experience and with our experienced programmers too. We ended up having to buy more copies."<br /> —Norm Yates (Network Manager, Maine Maritime Academy, USA) on the previous edition.</p>

US