|
About the Book
The definitive guide to building enterprise solutions with Access Projects and SQL Server
Professional developers who use Microsoft® Access, the popular desktop database program, often confront limits to working with large amounts of data. This hands-on guide demonstrates in detail how to build powerful database solutions of unlimited size by retaining the familiar development environments of Access 2000 and Access 2002 while exploiting the enterprise-level power and performance of SQL Server™ 7.0 and SQL Server 2000. Find out how to use MSDE—the SQL Server version included with Microsoft Office Developer and Microsoft Visual Studio®—to store data on a SQL Server. Then learn how to create and use Access Projects, complete with queries, forms, reports, macros, and modules, to access SQL Server and MSDE databases. Topics covered include:
• Access Projects, database versions and installation, tables in Access Projects, database diagrams, views, stored procedures, and Transact-SQL
• Forms and reports
• Programming with ADO, connection objects, Recordset objects, Command and Parameter objects, and ADO events
• Using the Upsizing Assistant, and moving from DAO to ADO
• SQL Server and MSDE database administration, SQL Server tools, security, backup and recovery, data transformation services, SQL-DMO-Library, external data sources, and system procedures
• Multi-user transactions and locking
• Web publishing with the SQL Server Web Assistant Wizard, using XML with Access 2002 and SQL Server 2000
CD-ROM features:
• A fully searchable electronic version of the book
• SQL Server 7.0 Service Pack 3
• Microsoft SQL Server 2000 Enterprise Evaluation Edition
• A sample SQL Server database
Related Books
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization
MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft® SQL Server™ 2005
Microsoft® SQL Server™ 2005 Administrator's Companion
Customer Rating
Number of Ratings: 3
| Average Rating: |
|
|
