Upon completion of this course, the student will be able to: Identify the points of integration between Microsoft Office 2000 and SQL Server 7.0 for database development. Configure SQL Mail to work with Outlook 2000. Define the methods used by Excel 2000 to access enterprise data stored in SQL Server 7.0 databses. Define DSS and OLAP, and identify the methods used by Office 2000 to access data warehouses and data marts.
Unit 1: Office 2000 Integration
- Office Server Extensions
- SQL Mail and Microsoft Outlook 2000
- Access 2000
- Excel 2000
- Decision Support Services
Unit 2: Visual Studio Integration
- SQL-DMO
- DB-Library
- Developing SQL Server Applications with DAO
- Developing SQL Server Applications with ODBCDirect
- Developing Database Applications with RDO
- Developing Database Applications with ADO
- Visual Database Tools