Overview

Access 2000 is the fifth version of the hugely successful desktop database from Microsoft. When it was first released in 1992, Access immediately gained praise for its ease of use and power. Each release of Access has added features and increased usability, and with Access 2000 we now have a unified development environment for the whole of the Office 2000 suite of applications. Visual Basic for Applications (VBA) is the programming language that gives Access its real power, allowing you to automate complex tasks and create applications with more scope and flexibility than is possible with its default forms and macros. VBA has a simple syntax allowing even complete novices to learn programming with very little effort, and this book illustrates the concepts with plenty of examples and exercises. Who is this book for? 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. What does this b

Full Product Details

Author:   Robert Smith ,  David Sussman
Publisher:   John Wiley & Sons Inc
Imprint:   Hungry Minds Inc,U.S.
Edition:   New edition
Dimensions:   Width: 18.50cm , Height: 4.90cm , Length: 20.80cm
Weight:   1.295kg
ISBN:  

9780764543838

ISBN 10:   0764543830
Pages:   896
Publication Date:   03 April 2000
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Out of Stock Indefinitely
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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.

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions