Book description
Developing applications for the enterprise introduces challenges quite different from those associated with developing applications for desktops or small departments. This book offers a no-nonsense approach to enterprise development using Access 2002 as a front-end. it is written in a practical style and easily transitions the client/server neophyte to the sophisticated world of enterprise development. Although the book focuses on client/server development, the text covers other enterprise topics such as replication, trasaction processing, and data access pages. This book goes behond the basics covered by the many introductory books, but offers an easier read than the expert books available.
Table of contents
- Copyright
- About the Author
- Acknowledgments
- Tell Us What You Think!
- Introduction
-
Client/Server Development
-
A Strategy for Developing Access Applications
- Why This Chapter Is Important
- Access as a Development Tool
- Access as a Scalable Product
- Splitting Databases into Tables and Other Objects
- Understanding the Access Runtime Engine
- Using an EXE Versus Access Database: What It Means to You
- Understanding the Importance of Securing Your Database
- Using Access as a Front End
- Summary
-
Developing Multiuser Applications
- Why This Chapter Is Important
- Designing Your Application with Multiuser Issues in Mind
- Understanding Access's Locking Mechanisms
- Locking and Refreshing Strategies
- Form-Locking Strategies
- Recordset Locking
- Effectively Handling Locking Conflicts
- Testing a Record for Locking Status
- Using Code to Refresh or Requery
- Understanding the .LDB File
- The User Roster
- Creating Custom Counters
- Using Unbound Forms
- Using Replication to Improve Performance
- Summary
-
Introduction to Client/Server Development Techniques
- Why This Chapter Is Important
- Understanding the Client/Server Model
- Deciding Whether to Use the Client/Server Model
- The Roles Access Plays in the Application Design Model
- Learning the Client/Server Buzzwords
- Upsizing: What to Worry About
- Proactively Preparing for Upsizing
- Using the Upsizing Wizard
- Defining an ODBC Data Source
- Connecting to a Database Server
- Summary
-
SQL Server Basics
- Why This Chapter Is Important
- Editions of SQL Server Available
- Overview of the SQL Server Components
- Introduction to the Enterprise Manager
- Introduction to the Query Analyzer
- Introduction to the Profiler
- Introduction to Data Transformation Services
- Configuring the Server
- Designing and Creating a SQL Server Database
- Summary
-
SQL Server Tables and Database Diagrams
- Why This Chapter Is Important
- Creating SQL Server Tables
- Working with Constraints
- Identity Columns
- Working with Computed Columns
- Working with User-Defined Data Types
- Adding and Modifying Indexes
- An Introduction to Triggers
- An Introduction to Relationships
- Establishing Relationships Between SQL Server Tables
- Establishing Referential Integrity
- Looking at the Benefits of Relationships
- Examining Indexes and Relationships
- Summary
- Mastering T-SQL
- Working with SQL Server Views
-
Designing SQL Server Stored Procedures, User-Defined Functions, and Triggers
- Why This Chapter Is Important
- Stored Procedure Basics
- Declaring and Working with Variables
- Controlling the Flow
- The SET NOCOUNT Statement
- Using the @@Functions
- Working with Parameters
- Modifying Data with Stored Procedures
- Errors and Error Handling
- Stored Procedures and Transactions
- Stored Procedures and Temporary Tables
- Stored Procedures and Security
- Debugging the Stored Procedures That You Build
- Building and Working with User-Defined Functions
- Creating and Working with Triggers
- Summary
- SQL Server Security
- ADO and SQL Server
-
Developing an MDB Client/Server Application with Linked Tables
- Why This Chapter Is Important
- What Is a Linked Client/Server Application?
- How Linked Table Applications Work
- Working with Linked Tables
- Using Pass-Through Queries
- Executing Stored Procedures
- Building Client/Server–Friendly Forms
- Working with Local Tables
- Populating Combo Boxes and List Boxes Dynamically
- Building Client/Server–Friendly Reports
- Linked Table Gotchas
- Summary
- Developing an ADP Application
- Building Unbound Applications
- Building N-Tier Applications
- Configuring, Maintaining, and Tuning SQL Server
-
A Strategy for Developing Access Applications
-
Access Enterprise Techniques
-
Transaction Processing
- Why This Chapter Is Important
- Understanding the Benefits
- Modifying the Default Behavior
- Implementing Explicit Transaction Processing
- Looking at Transaction Processing Issues
- Using Transaction Processing in a Multiuser Environment
- Using Transaction Processing in a Client/Server Environment
- Practical Examples: Using Transaction Processing to Improve the Integrity of Your Applications
- Summary
-
Access Replication Made Easy
- Why This Chapter Is Important
- Uses of Replication
- Understanding When Replication Isn't Appropriate
- Understanding the Implementation of Replication
- Understanding the Replication Architecture: What Makes Replication Tick?
- Understanding Replication Topologies
- Changes That Replication Makes to Your Database
- Making a Database Replicable
- Preventing Objects from Being Replicated
- Creating Additional Replicas
- Synchronizing Replicas
- Resolving Replication Conflicts
- Using the Replication Manager
- Using Partial Replication
- Implementing Replication Using Code
- Practical Examples: Managing the Time and Billing Application with Replication
- Summary
- Taking Advantage of the Microsoft Office XP Developer
-
Source Code Control
- Why This Chapter Is Important
- How Do I Install Visual SourceSafe?
- Using Visual SourceSafe: An Overview
- The Logistics of Managing a Project with Visual SourceSafe
- Leveraging the Power of Visual SourceSafe
- Changes Visual SourceSafe Makes to Access's Behavior
- Understanding the Limitations of Visual SourceSafe
- Summary
-
Transaction Processing
-
Access and the Internet
- Publishing Data on the Web
-
XML Support in Microsoft Access
- Why This Chapter Is Important
- The Basics of XML
- Exporting Data to XML
- Working with XML Style Sheets (XSL or XSLT)
- Working with XML Schemas—The XSD File
- Exporting Gotchas
- Exporting Forms and Reports to XML
- Importing XML Data into Access
- Programmatically Importing and Exporting XML Data
- Using ADO Code to Work with XML
- Summary
- Data Access Pages
- SQL Server and the Internet
- Index
Product information
- Title: Alison Balter's Mastering Access 2002 Enterprise Development
- Author(s):
- Release date: June 2002
- Publisher(s): Sams
- ISBN: 9780672321139
You might also like
book
Alison Balter’s Mastering Microsoft® Office Access 2007 Development
Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also …
book
Special Edition Using Microsoft® Office Access 2003
Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of …
book
A Developer’s Guide to SQL Server 2005
"I come from a T-SQL background, so when I first laid my eyes on SQL Server …
book
Pro Access 2010 Development
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of …