Access 2003 Power Programming with VBA
Editorial Reviews
Amazon.com
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.
Book Description
Everything you need to know about Using modules, procedures, and functions Coding with Visual Basicandreg; Editor Understanding Access events and interacting with other applications Programming menus and toolbars Developing user-oriented and multi-user applications Manipulating Visual Basicandreg; 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.
Access 2003 Power Programming with VBA
Access 2003 Power Programming with VBA,Allen G. Taylor,Virginia Andersen,Wiley,0764525883,Basic (Programming Language),Computer Bks - Languages / Programming,Computer Books: General,Computers,Database Management - General,Database management,Microcomputer Database Management Software,Microsoft Access,Microsoft Visual Basic for app,Microsoft Visual Basic for applications,Programming - Visual Basic - VBA (Visual Basic for Applicati,Programming Languages - Visual BASIC,Computer Programming,Computers / Database Management / General,Database software,Databases & data structures
Access 2003 Power Programming with VBA
Books:
Books