Professional Access 2000 Programming
Ian Blackburn, Brian Matsik, David Sussman, Turley
Résumé
- Access essentials including good database design, efficient querying, forms and reports, VBA, and security
- ActiveX controls and COM add-ins for your application
- Integrating Access with other Office applications into a single solution
- Packaging and deploying your application to the enterprise or Internet
- How to use Access as a front end to a SQL Server database
- Creating a Help system for your application
- Replicating your database, and creating scalable applications
- Creating Data Access Pages for quick access to your data over an intranet
- Validation, error handling and debugging
Book overview
Access 2000 is the database of choice for many small to medium businesses. Using Access in conjunction with VBA or ASP, it is possible to develop sophisticated systems for storing and manipulating business data. Office 2000 and Access 2000 offer many new features that can be used to create Internet-enabled applications and user interfaces. In addition, the introduction of the Microsoft Data Engine (MSDE) means that Access 2000 is compatible with Microsoft SQL Server and so applications can be easily upsized and integrated with this larger database system.
Professional Access 2000 Programming provides a thorough guide to developing sophisticated custom database applications with Access 2000.
Who is this book for?
This book is intended for developers who already have a knowledge of databases and the basic Access objects and wish to use more advanced features and create feature complete, database driven applications that can be deployed to the desktop, the enterprise, or the Internet.
Summary of Contents
Introduction
Chapter 1: Access 2000 - Overview
Chapter 2: Developing Access Applications
Chapter 3: VBA and Access Objects
Chapter 4: Querying the Database
Chapter 5: Forms and Reports
Chapter 6: Data Validation within Access
Chapter 7: Making Your Application Bulletproof
Chapter 8: Object-Oriented Programming in Access
Chapter 9: Putting Data on the Internet
Chapter 10: Enhancing Your Applications with ActiveX
Controls
Chapter 11: Creating a Help System
Chapter 12: Enhancing Access with Office Applications
Chapter 13: COM Add-Ins
Chapter 14: Replication
Chapter 15: Security
Chapter 16: Distributing an Access Solution
Chapter 17: Building Scalable Systems
Chapter 18: Access Projects with SQL Server
Appendix A: Access Object Model
Appendix B: Access Events
Appendix C: ADO 2.1 Object Model
Appendix D: Microsoft DAO 3.6 Object Library
Reference
Appendix E: JRO Object Summary
Appendix F: Quick VBA Reference
Appendix G: Jet SQL
Appendix H: Active Server Pages
L'auteur - David Sussman
David Sussman 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.
Dave Sussman speaks frequently at Microsoft development conferences and has been writing about ASP since its earliest releases.
Autres livres de David Sussman
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wrox Press |
Auteur(s) | Ian Blackburn, Brian Matsik, David Sussman, Turley |
Parution | 15/09/2000 |
Nb. de pages | 906 |
Intérieur | Noir et Blanc |
EAN13 | 9781861004086 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse