Ebook: Beginning Access 2002 VBA

Access 2002 is the core database application within the Office XP suite. This book focuses on the programming language that underlies Access 2002 (and all the other office products) – VBA (Visual Basic for Applications).

While you can achieve a great deal in Access without ever knowing anything about programming, sooner or later you will want to develop applications with greater scope and flexibility, and a professional feel and functionality - this is where VBA comes into its own.

Using VBA with Access is an incredibly powerful technique as, amongst other things, it allows you to create custom user interfaces, to automate complex tasks, to integrate Access with other parts of the Office suite, and to provide enhanced security for your database.

VBA has a very simple syntax which makes it an ideal starting place for novice programmers and a perfect lead in to Microsoft's popular programming language, Visual Basic. This book covers everything you need to gain the confidence and knowledge to go away and begin to write your own programs. All the concepts are illustrated with plenty of interesting and practical examples and exercises.

This book is a revision of the best-selling Beginning Access 97 and Beginning Access 2000 VBA books, reworked to provide a rich tutorial to programming Access 2002 with VBA. New material covers the enhanced XML, integrating with SQL Server Desktop Engine, and so on.