Beginning Access 2000 VBA View Larger Image | Dave Sussman, Robert Smith
Wrox Press, Paperback, Bk&CD edition, Published April 2000, 865 pages, ISBN 0764543830 | List Price: $39.99
Our Price: $25.50
You Save: $14.49 (36% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!Books on similar topics, in best-seller order: Books from the same publisher, in best-seller order:
Access 2000 is an important part of the Office 2000 program suite, and is available
on both the Premium and Professional editions of Office 2000. Access has traditionally
been the Office suite database program par excellence. It still remains that
way, but with Office 2000 the face of Access is changing. This book will look
at the traditional role of Access and its future uses in the Office suite.
Using VBA (Visual Basic for Applications), the user can program his or her
own programs in what is essentially a subset of the Visual Basic programming
languages. This is tremendously powerful, as it allows you to create great User
Interfaces (forms etc), as a front end to actual database storage and manipulation.
This continues to be one of the great strengths of programming Access VBA.
This book updates, expands and improves Beginning Access 97 VBA Programming,
in an Office 2000 setting. All the great tutorial content, teaching people how
to program with VBA in Access is there, but now majorly rewritten to take account
of Office 2000.
Updated to take account of the Office 2000 facilities
Constructs a substantial example application with VBA
Database theory taught in the Wrox Beginning style
- In this book, you will learn how to
-
Construct a substantial example application with VBA
-
Master the foundations of Visual Basic for Applications
-
Understand the concepts behind classes and objects
-
Understand how Automation can be used to link Office applications
-
Create custom objects using the Class Module feature
-
Debug your programs and implement robust error handling
-
Add support for multiple users
-
Publish your Access database on the Internet
-
Optimize and add polish to your finished database application
This book is for users who already have a basic knowledge of databases and
the basic Access objects, such as tables, queries, forms and reports. You now
want to expand on your existing knowledge of Access and wish to learn how to
program in VBA. You don't need any prior programming experience, although a
basic knowledge of Access macros would be helpful.
Table of Contents
Introduction.
Chapter 1. Access 2000 – A Long Journey.
Chapter 2. Designing Applications.
Chapter 3. Introduction to Event Driven Programming.
Chapter 4. Creating Code.
Chapter 5. Controlling the Program.
Chapter 6. Using Access Objects.
Chapter 7. Using DAO.
Chapter 8. Data Management Techniques.
Chapter 9. External Data.
Chapter 10. Reports.
Chapter 11. Advanced Programming Techniques.
Chapter 12. Error Handling and Debugging.
Chapter 13. Using Classes.
Chapter 14. Libraries and Add-Ins.
Chapter 15. Automation.
Chapter 16. Multi-User.
Chapter 17. The Internet.
Chapter 18. Optimizing Your Application.
Exercise Solutions.
Appendix A. Choosing Between MSDE and Jet.
Appendix B. Choosing Between DAO and ADO.
Appendix C. ADO 2.1 Object Model.
Appendix D. Access Object Model.
Appendix E. Microsoft DAO 3.6 Object Library Reference.
Appendix F. Access Events.
Appendix G. ANSI Character Set.
Appendix H. ODBC and PWS.
About the Authors
Robert Smith and David Sussman have been programming
in Access since it was first released. Using their experience they teach you
how the power of Visual Basic for Applications can transform ordinary databases
into great applications.
|
