Access 2003 Power Programming with VBA
1st Edition
Published on 31. October 2003
Book
Paperback/Softback
696 pages
978-0-7645-2588-9 (ISBN)
Description
* 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
* 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
More details
Edition
1., Auflage
Language
English
Place of publication
Foster City
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.4 cm
Width: 18.9 cm
Thickness: 3.7 cm
Weight
964 gr
ISBN-13
978-0-7645-2588-9 (9780764525889)
Schweitzer Classification
Persons
Allen G. Taylor (Oregon City, Oregon) is a Database Consultant and National Speaker. He is a 30-year veteran of the computer industry and the author of 20 computer-related books. He has held the following titles at various companies: E-Business Technical Services Director; Programming Group Manager; and Assistant Professor in Pacific University's Computer Science Department. Allen's previous published books include the following: SQL Weekend Crash Course (Wiley); SQL For Dummies (1st through 4th Editions, Wiley); Database Design For Dummies (Wiley); and dBase for Windows Solutions (Wiley).
Virginia Andersen (Coronado, CA) has over 25 years experience working on computer science applications, analysis, and engineering that support government and defense projects. She is a certified MOUS expert in Access 2000 and the author of several advanced Access programming and troubleshooting books, including Access 2002: The Complete Reference (Osborne M-H).
Virginia Andersen (Coronado, CA) has over 25 years experience working on computer science applications, analysis, and engineering that support government and defense projects. She is a certified MOUS expert in Access 2000 and the author of several advanced Access programming and troubleshooting books, including Access 2002: The Complete Reference (Osborne M-H).
Content
Acknowledgments.
Part I: Access Application Development.
Chapter 1: Access Application Development.
Chapter 2: Essentials of Database Application Development.
Chapter 3: Access Application Development without VBA.
Chapter 4: Customizing Menus and Toolbars.
Part II: Understanding Visual Basic for Applications.
Chapter 5: Introducing Visual Basic for Applications.
Chapter 6: VBA Programming Fundamentals.
Chapter 7: The Visual Basic Editor.
Chapter 8: Using VBA Language Elements.
Chapter 9: Building a Sub Procedure.
Chapter 10: Running and Debugging VBA Code.
Chapter 11: Creating Function Procedures.
Part III: Programming User Interactions with VBA.
Chapter 12: Building User Interaction.
Chapter 13: Programming Menus and Toolbars.
Chapter 14: Changing the Workplace with VBA.
Part IV: Advanced Access Programming Techniques with VBA.
Chapter 15: Connecting to Databases with ADO.
Chapter 16: Access Events.
Chapter 17: Interacting with Other Applications.
Chapter 18: XML Support.
Chapter 19: Add-Ins.
Part V: Developing Applications with VBA.
Chapter 20: Developing User-Oriented Applications.
Chapter 21: Developing Multi-User Applications.
Part VI: Other Important Topics.
Chapter 22: Compatibility Issues.
Part VII: Appendixes.
Appendix A: Helpful Web Links.
Appendix B: VBA Statements and Functions.
Appendix C: VBA Constants.
Appendix D: VBA Error Codes.
Appendix E: ANSI Codes.
Index.
Part I: Access Application Development.
Chapter 1: Access Application Development.
Chapter 2: Essentials of Database Application Development.
Chapter 3: Access Application Development without VBA.
Chapter 4: Customizing Menus and Toolbars.
Part II: Understanding Visual Basic for Applications.
Chapter 5: Introducing Visual Basic for Applications.
Chapter 6: VBA Programming Fundamentals.
Chapter 7: The Visual Basic Editor.
Chapter 8: Using VBA Language Elements.
Chapter 9: Building a Sub Procedure.
Chapter 10: Running and Debugging VBA Code.
Chapter 11: Creating Function Procedures.
Part III: Programming User Interactions with VBA.
Chapter 12: Building User Interaction.
Chapter 13: Programming Menus and Toolbars.
Chapter 14: Changing the Workplace with VBA.
Part IV: Advanced Access Programming Techniques with VBA.
Chapter 15: Connecting to Databases with ADO.
Chapter 16: Access Events.
Chapter 17: Interacting with Other Applications.
Chapter 18: XML Support.
Chapter 19: Add-Ins.
Part V: Developing Applications with VBA.
Chapter 20: Developing User-Oriented Applications.
Chapter 21: Developing Multi-User Applications.
Part VI: Other Important Topics.
Chapter 22: Compatibility Issues.
Part VII: Appendixes.
Appendix A: Helpful Web Links.
Appendix B: VBA Statements and Functions.
Appendix C: VBA Constants.
Appendix D: VBA Error Codes.
Appendix E: ANSI Codes.
Index.