Albrecht, Ralf.

Microsoft Access projects with Microsoft SQL server / Ralf Albrecht, Natasha Nicol - Redmond, Wash. : Microsoft Press, c2002. - xiv, 637 p. : ill. ; 24 cm. + electronic optical disc (CD-ROM) (4 3/4 in.).

Pt. I. Microsoft access projects and microsoft SQL server. 1. Introduction to microsoft SQL server and access. 2. Access projects. 3. Installation. 4. Databases. 6. 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. The 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. VII. Appendices. A. Naming conventions. - B. Internet addresses. - C. SQL server/MSDE specifications. - Index.

0735610029


SQL server.


Client/server computing.

005.7585 / ALB