MS Press - Microsoft Access Projects with Microsoft SQL Server
Cover
LOC
Part I - Microsoft Access Projects and Microsoft SQL Server
Introduction to Microsoft SQL Server and Access
Who Should Read This Book?
Chapter Overview
The Sample Database
System Requirements
Access Projects
Interfaces
Access Projects
SQL Server and MSDE
Standalone, Network, and Client Server
Installation
Installing SQL Server 2000
Installing MSDE 2000
Installing SQL Server 7
Installing MSDE 1
Running SQL Server/MSDE
Databases
SQL Server/MSDE Databases
Creating a New Access Project
Tables in Access Projects
Creating Tables
Indexes for Tables
Copying Tables
Working with Tables
System Tables
Database Diagrams
Creating a Database Diagram
Editing Tables
Defining Relationships
The Properties Dialog Box
Diagram View
Views
Access Queries vs. Views
Creating Views
Query Designer Areas
Adding Tables or Views
Selecting Columns
Aliases
Saving a View
Executing a View
Datasheet View
Criteria
Joins
Groups
Calculated Columns
Properties of a View
Union Queries
Subqueries
Creating Views with SQL
Stored Procedures
Creating Stored Procedures
Parameters and Variables
Transact-SQL Program Commands
Triggers
Searching for Errors in Stored Procedures
User-Defined Functions
Transact-SQL
Select Queries with SELECT
Calculated Columns
SQL Functions
Part II - Forms and Reports
Forms
Record Source
Editing Data in Forms
The InputParameters Property
Referencing Forms and Reports
Synchronized Subforms
Form Filters
General
Opening Forms with VBA
Reports
Creating Reports
Subreports
Opening Reports with DoCmd.OpenReport
Part III - Programming with ADO
Connection Objects
Connection Strings
Connection Objects in Access Projects
The Open Method
Other Properties and Methods
The Errors Collection
Recordset Objects
Understanding Recordsets
Opening a Recordset
Working with Recordsets
Searching Records
Sorting Recordsets
Editing Data
The GetRows Method
The GetString Method
The Clone Method
The Requery and Resync Methods
State Properties
Batch Processing
Recordsets Without a Database Connection
Working with Multiple Recordsets
Saving Recordsets
Command Objects
Using Command Objects
Queries with Parameters
ADO Events
Events
Asynchronous Queries
Part IV - Upsizing
Upsizing Wizard
The Upsizing Wizard
Converting Tables
Porting Relationships
Upsizing Queries
Converting Forms and Reports
Converting VBA Programs
From DAO to ADO
Basics
Opening a Database
Accessing the Data by Recordset
Executing Queries
DAO in Access Projects
Part V - SQL Server/MSDE Administration
Database Administration
Creating Databases
Deleting Databases
Additional Administration Functions
SQL Server Tools
Enterprise Manager
Query Analyzer
The OSQL Program
Profiler
Security
Security for .Adp Files
Securing VBA Modules
Security with SQL Server/MSDE
User Administration with SQL Server Enterprise Manager
SQL Commands for Granting Permissions
System Stored Procedures for Users and Roles
Data Backup Functions
Basics
Data Backup Functions
Restoring Data
Data Transformation Services
The DTS Wizard
DTS in Enterprise Manager
The SQL-DMO Library
Object Model
A Script for All Database Objects
Setting Up the SQL-DMO Library
External Data Sources
Setting Up a Linked Server
Data Access to Linked Servers
Ad-Hoc Accesses
Linked Tables in Access 2002
System Stored Procedures
Grouped by Function
Alphabetical List
Part VI - Transactions and Locks
Transactions and Locking
Locking Records
Part VII - Internet
Web Publishing with SQL Server
The SQL Server Web Assistant Wizard
XML with Access 2002 and SQL Server 2000
XML with Access 2002
XML with SQL Server 2000
Part VIII - Appendices
Naming Conventions
Hungarian Notation
Tags
Creating Data Types
Creating Procedures
Prefixes
Suffixes
Tags for Access
Tags for ADO
Tags for SQL Server Objects
Internet Addresses
Newsgroups
SQL Server/MSDE Specifications