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: Other Applications 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 Author

Robert Smith Robert Smith is a graduate of Oxford University who has been working for Anthony Coook Associates since 1994. He has been developing with Access since its first release in 1992. About half of his time is psent developing with Access and SQL Server anf the remainder is spent on consultancy in client/server design and development issues. David Sussman David gained experience in BASIC, Pascal, COBOL and OCCAM, before joining a UNIX system house where he stayed for 4 years, becoming the chief UNIX/C guru. For the last 3 years he has been working for a Microsoft Solution Provider, specializing in Access, VB and SQL Server, as well as playing extensively with every Beta product that comes his way.