附註:Includes index.
Title from title screen.
pt. I. Microsoft Access Projects and Microsoft SQL Server -- 1. Introduction to Microsoft SQL Server and Access -- 2. Access Projects -- 3. Installation -- 4. Databases -- 5. Tables in Access Projects -- 6. Database Diagrams -- 7. Views -- 8. Stored Procedures -- 9. Transact-SQL -- pt. II. Forms and Reports -- 10. Forms -- 11. Reports -- pt. III. Programming with ADO -- 12. Connection Objects -- 13. Recordset Objects -- 14. Command Objects -- 15. ADO Events -- pt. IV. Upsizing -- 16. Upsizing Wizard -- 17. From DAO to ADO -- pt. V. SQL Server/MSDE Administration -- 18. Database Administration -- 19. SQL Server Tools -- 20. Security -- 21. Data Backup Functions -- 22. Data Transformation Services -- 23. SQL-DMO Library -- 24. External Data Sources -- 25. System Stored Procedures -- pt. VI. Transactions and Locks -- 26. Transactions and Locking -- pt. VII. Internet -- 27. Web Publishing with SQL Server -- 28. XML with Access 2002 and SQL Server 2000 -- pt. VIII. Appendices -- A. Naming Conventions -- C. SQL Server/MSDE Specifications.
摘要:Provides hands-on guidance that professional Access programmers need to fully exploit the world-class scalability and knowledge-management capabilities in SQL Server 2000. Focuses on understanding and using the innovative MSDE technology that serves as the powerful core of SQL Server 2000. Softcover. CD-ROM included.
