Description:
Professional SQL Server Development with Access 2000 shows the experienced database programmer or administrator how to take advantage of SQL Server using the built-in tools and capabilities of Access 2000. Filled with screen shots and plenty of practical advice for working with data, this book proves that Access is a great tool for getting the most out of SQL Server. Usually associated with the lower end, Access 2000 has clearly grown up with the features that let you connect to SQL Server 7/2000, but with the convenience of a graphical tool. The book covers not only the features of Microsoft databases, but also how to rely on Access 2000 as your tool of choice for common administrative and programming tasks. Starting from table design, and the powerful database diagramming tools available in Access, you learn how to create effective database designs. And a full discussion of joins, indexes, constraints, views, and other advanced features make this book good for even more advanced readers. Besides admin functionality, there's coverage of VBA for database programmers, and T-SQL (Microsoft's version of SQL), including an excellent section on stored procedures and triggers. While there's a lot of textual description in this book, there are also plenty of easy-to-understand screen shots, making this a useful resource to have at your desk. The graphics that detail the use of Access 2000 toolbars (which list the functions for each tiny button) are very good. The tutorial turns toward using Access 2000 features (forms and reports) to work with SQL Server data on the back end. Later sections examine the options you have for Web development, including Access's own Data Access Pages, data sheets, and a short introduction to using Active Server Pages on Microsoft IIS. Reference sections of database security and upsizing older Access databases to SQL Server help round out this comprehensive and thoughtfully written book, which shows that Access 2000 really can let you access higher-end features on today's Windows platform. This book is perfect for any administrator or database programmer who wants to benefit from Access and SQL Server used together. --Richard Dragan Topics covered: - Introduction to relational databases and Access 2000
- Installing SQL Server 7/2000 and the Microsoft Data Engine (MSDE)
- SQL Server data types
- Creating and managing tables
- Using constraints
- Database diagramming in Access 2000
- Using SQL Server views
- Programming the SQL Distributed Management Objects (SQL-DMO)
- Stored procedures and triggers (including VBA and ADO programming techniques)
- Access forms (bound and programmatic access to form controls)
- Report design in Access 2000 (including conditional formatting and charts)
- Publishing datasheets for Internet applications
- Quick introduction to form design using Active Server Pages (ASPs)
- Data Access Pages
- Office Web Components (including spread sheets and charts)
- Programming SQL Server in Access (including basic ADO programming)
- SQL Server security tutorial
- Upsizing Access databases to SQL Server
- ADO 2.1 object model reference
| 
