Normal view MARC view ISBD view

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

By: Albrecht, Ralf.
Contributor(s): Nicol, Natascha [(j.a.)].
Publisher: Redmond, Wash. : Microsoft Press, c2002Description: xiv, 637 p. : ill. ; 24 cm. + electronic optical disc (CD-ROM) (4 3/4 in.).ISBN: 0735610029.Subject(s): SQL server | Client/server computingDDC classification: 005.7585
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.
Item type Current location Call number Vol info Copy number Status Notes Date due Barcode Remark
Accompanying Material (Media Resource) TU External Storage-LCS
005.7585 ALB (Browse shelf) CD-ROM 1 Available SOCIT, CD540231/540840 1000112692 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

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.