Access?2003 Power Programming with VBA - Softcover

Taylor, Allen G.; Andersen, Virginia

Softcover

ISBN 10: 0764525883 ISBN 13: 9780764525889

Publisher: Wiley, 2003

Synopsis

* As part of the Power Pack family of books, this book gives programmers and advanced Access users the knowledge they need to master the power within Access-the world's most widely used database management system
* Shows how to use VBA to design efficient, user-friendly end-user applications in Access
* Starts with database concepts and event-driven programming, then covers VBA programming fundamentals, the Visual Basic Editor, VBA language elements, and code debugging
* Covers advanced Access programming techniques like connecting to databases with ADO and interacting with other applications
* Includes helpful discussions on compatibility issues and manipulating Visual Basic components
* Companion Web site includes all the code examples in the book

About this title

Review

Microsoft Access remains an important part of the Windows developer's environment, in that the doughty database management system represents a simple and relatively straightforward core for forms-based software modules. Access 2003 Power Programming with VBA is a resource for programmers (particularly novice ones) working with Access and its native tongue, Visual Basic for Applications (VBA). The emphasis in these pages falls on getting specific tasks done (examples include modifying a stock menu bar, connecting to data sources, listening for interface events, and exporting XML). Other coverage is more basic, and appropriate for Access developers in their novitiate stage. It deals with such fundamentals as declaring variables, establishing control structures (such as loops and case statements), and using the features of the Visual Basic Editor.

Will this book help you? Probably, to some extent. It's well-written and the authors have made wise decisions about which aspects of the Access universe to include and which to leave out (Access is a big subject). Their explanatory sections are clear and easy to follow, and their code is clever enough. On the other hand, the odds are small that you'll get all the information you need out of this book, unless the application you want to write is super-simple. Take this book as one step in a potentially long journey toward the application you want, and in an even longer one toward VBA mastery. --David Wall

Topics covered: The most important tools and techniques to be used in writing applications based on Microsoft Access 2003. Software design and the differences among the many Access releases are covered at first, and a clever section on Access development without VBA explains database schema development and the use of standard forms. Most of the book deals with VBA, though, including its capacity to create graphical user interfaces, connect to databases, integrate with other applications, and work with XML data. A chapter on multi-user applications (which has mainly to do with database locking) is helpful.

From the Back Cover

Everything you need to know about

• Using modules, procedures, and functions
• Coding with Visual Basic® Editor
• Understanding Access events and interacting with other applications
• Programming menus and toolbars
• Developing user-oriented and multi-user applications
• Manipulating Visual Basic® components

Here’s how to harness the power of VBA

Visual Basic for Applications (VBA) is power-packed. This book gives you command of that power to build sophisticated applications in the perfect development environment Access provides. First, you’ll get VBA programming fundamentals and an understanding of the Visual Basic Editor, VBA language elements, and code debugging. Then you’ll go deeper into programming user interactions, connecting to databases with ADO, developing multi-user applications, and much more. Here is the knowledge that can take you from power user to power developer.

Edition details

• Publisher: Wiley
• Publication date: 2003
• ISBN 10: 0764525883
• ISBN 13: 9780764525889
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 696