Access Projects with SQL Server

Natascha Nicol

638 pages, parution le 31/01/2002

Ajouter à une liste

Indisponible

Résumé

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

Contents

Part I : Microsoft Access Projects and Microsoft SQL Server

1/ Introduction to Microsoft SQL Server and Access
2/ Access Projects
3/ Installation
4/ Databases
5/ Tables in Access Projects
6/ Database Diagrams
7/ Views
8/ Stored Procedures
9/ Transact - SQL

Part II : Forms and Reports

10/ Forms
11/ reports

Part III : Programming with ADO

12/ Connection Objects
13/ Recordset Objects
14/ Command Objects
15/ ADO Events

Part IV : Upsizing

16/ Upsizing Wizard
17/ From DAO to ADO

Part 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

Part VI : Transactions and Locks

26/ Transactions and Locking

Part VII : Internet

27/ Web Publishing with SGL Server
28/ XML with Access 2002 and SQL Server 2000

Part VIII : Appendices

A/ Namming Conventions
B/ Internet Addresses
C/ SQL Server/MSDE Specifications

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Natascha Nicol
Parution	31/01/2002
Nb. de pages	638
Format	18,5 x 23,5
Couverture	Broché
Poids	1299g
Intérieur	Noir et Blanc
EAN13	9780735610026