Special Offers

Microsoft® Access Projects with Microsoft SQL Server™
Author Ralf Albrecht and Natascha Nicol
Pages 656
Disk 1 Companion CD(s)
Level Intermediate
Published 01/16/2002
ISBN 9780735610026
ISBN-10 0-7356-1002-9
Price(USD) $59.99
To see this book's discounted price, select a reseller below.

More Information

About the Book
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books

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: 4 stars

Rate this book

Top of Page

Last Updated: Friday, December 01, 2006