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