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.7585Item 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.