Includes bibliographical references and index.

. DATABASE DESIGN UNLEASHED. 1. What's New For Developers In Access 2000. New User Interface. Changes to the VBE. Data Access Pages. Subdatasheets. Name AutoCorrect. ADO Is the Default Data Access Method. Online Collaboration. Access as a Front-End to SQL Server. Summary. 2. Planning The Development Process. Gathering Requirements. Architecture. Development Planning. Construction. Summary. 3. Database Design And Normalization. Relational Database Management Systems (RDBMS). The Relational Design Theory. Summary. 4. Advanced Queries. Understanding Queries in Access 2000. Creating Advanced Queries. Using the Query Object. Understanding Query Properties. Understanding the QBE Grid. Understanding the Table Pane. Understanding the Query Grid. Mastering Totals Queries. Using Crosstab Queries. Using Parameter Queries. Understanding Pass-Through Queries. Understanding Data Definition Queries. Optimizing Queries. Summary. 5. The Microsoft Jet Database Engine 4.0. The History of Microsoft Jet. Using the New Jet 4.0 Features in Your Applications. Summary. II. DATA ACCESS. 6. Introduction To ActiveX Data Objects. History of Data Access. Microsoft's Universal Data Access Initiative. ActiveX Data Objects (ADO). The ADO Object Model. ADO Recordset Object. The Error Object. Moving from DAO to ADO. The ADO Object Model Compared to DAO. Summary. 7. Advanced ADO. Using the OLE DB Provider for Jet in Access 2000. Accessing Nonrelational Data with ADO. Advanced Data Manipulation with ADO. Data Definition with ADOx. Summary. III. USER INTERFACES UNLEASHED. 8. Advanced Form Design. Form Properties. Access Form Controls. Summary. 9. Enhancing Forms With ActiveX Controls. How to Use ActiveX Controls. Using ActiveX Controls. 21. ActiveX Controls. Distributing ActiveX Controls. Summary. 10. Reporting Unleashed. Approaching Reports. Understanding the Architecture of Access Reports. Building a Single Table Report Using the Report Wizard. Customiz

Access 2000 Unleashed provides the experienced Access user with information needed for high-end enterprise applications. This includes both Jet engine multi-user applications and SQL Server enterprise applications. This book will strengthen your existing Access knowledge and move you to a professional level of development. Written by respected Access professionals, this book also provides real world examples for business solutions and advice from years of working experience. Topics include: Database Design; Data Access; VBA; Access Client/Server; User Interfaces; Interoperability; Multi-User Issues; and Web Publishing with Access 2000.