Taylor's Library Banner
Image from Google Jackets

Microsoft Access projects with Microsoft SQL server / Ralf Albrecht, Natasha Nicol

By: Contributor(s): Publication details: Redmond, Wash. : Microsoft Press, c2002.Description: xiv, 637 p. : ill. ; 24 cm. + electronic optical disc (CD-ROM) (4 3/4 in.)ISBN:
  • 0735610029
Subject(s): DDC classification:
  • 005.7585 ALB
Contents:
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.
No physical items for this record

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.