Skip to content

Access 2002 Development Unleashed

ISBN-10: 0672321203

ISBN-13: 9780672321207

Edition: 2002

Authors: Stephen Forte, Tom Howe, James Ralston, Paul Kimmel, Russell Mullen

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

This comprehensive treatment of Access 2002 is indispensable for any serious Access developer as a tutorial and solution reference.
Customers also bought

Book details

List price: $49.99
Copyright year: 2002
Publisher: Sams
Publication date: 10/12/2001
Binding: Paperback
Pages: 864
Size: 7.25" wide x 9.00" long x 2.00" tall
Weight: 3.036
Language: English

Introduction
Database Design Unleashed
What's New for Developers in Access 2002
User Interface Changes
Changes to the VBE
Compatibility with Access 2000 Databases
Database Conversion Error Logging
Offline Data Access Pages
Improved Integration with SQL Server 2000
Other Access 2002 Features
Summary
Planning the Development Process
Gathering Requirements
Architecture
Development Planning
Construction
Summary
Database Design and Normalization
The Relational Design Theory
Summary
Advanced Queries
Using the Query Object
Creating Queries in Access
Creating Advanced Queries
Mastering Totals Queries
Mastering Crosstab Queries
Mastering Parameter Queries
Mastering Pass-Through Queries
Mastering Data Definition Queries
Summary
The Microsoft Jet Database Engine
The History of Microsoft Jet
Using Jet 4.0 Features in Your Applications
Summary
Data Access
Introduction to ActiveX Data Objects
History of Data Access
Microsoft's Universal Data Access Initiative
ActiveX Data Objects (ADO)
The ADO Object Model
Moving from DAO to ADO
The ADO Object Model Compared to DAO
Summary
Advanced ADO
Using the OLE DB Provider for Jet in Access 2002
Accessing Non-Relational Data with ADO
Advanced Data Manipulation with ADO
Data Definition with ADOX
Summary
User Interfaces Unleashed
Advanced Form Design
Form Properties
Access Form Controls
Creating PivotTable and PivotChart Views
Summary
Enhancing Forms with ActiveX Controls
How to Use ActiveX Controls
Using ActiveX Controls
21 ActiveX Controls
Distributing ActiveX Controls
Summary
Reporting Unleashed
Approaching Reports
Understanding the Architecture of Access Reports
Building a Single Table Report Using the Report Wizard
Customizing Reports
Working with Subreports
Creating Simple Mailing Labels
Publishing a Report
Modifying a Report at Runtime
Building Reports Programmatically
Tips and Tricks
Summary
VBA Unleashed
Creating Objects with Class Modules
Exploring the Benefits of Using Objects
Reviewing Objects, Properties, and Methods
Creating Classes
Creating Properties
Creating Methods
Creating Events
Using Objects
Creating Multiple Instances of an Object
Examining More Object Examples
Implementing an Error Handler Object
Using Objects with VBA Collections
Summary
Debugging Access Applications
Eliminating Logic Errors
Working with the Visual Basic Development Environment (IDE)
Working with the Debug Object
Using the Immediate Window
Using the Debugger
Using Conditional Compilation
Application Testing
Practice Debugging Techniques
Summary
Professional Error Handling
Eliminating Syntax Errors
Eliminating Logic Errors
Eliminating Runtime Errors
Errors in Various Applications
Error Handling With Nested Procedures
Advanced Error Topics
Summary
Application Optimization
Strengthening the Foundation: Hardware and Windows Optimization
Installing the Application for Optimal Performance
Optimizing the Configuration of the Jet Database Engine
Tools to Measure Performance
Looking Behind the Scenes
Optimizing the Database from the Start
Boosting Query Performance
Getting Forms to Run Faster
Writing Fast Code
Coding Tips and Hints
Summary
Access Client Server
Introducing Access Data Projects and the Visual Tools
Introducing Access Data Projects
Using ADPs
Working with ADPs and Existing SQL Server Databases
Creating a Project Based on a New Database
Summary
Developing Access Front-Ends to Microsoft SQL Server
Client/Server Architecture: OLE DB Versus ODBC
Setting Up Your SQL Server Front-End Connection
Stored Procedures and SQL Pass-Through Queries
Reporting Against SQL Server in Access 2002
Using Forms in Your Application
Advanced Features of the SQL Server OLE DB Provider
Executing Commands with Parameters
Using a Connection Class
Summary
Access 2002 Front-Ends to Oracle
Accessing Oracle Data with Access
Functions in Oracle Versus Access
Understanding Views and Stored Procedures
Creating an Unbound Interface to Oracle
Summary
Interoperability
Using ActiveX Automation
What Is ActiveX Automation?
Why Use Automation?
Distinguishing Automation Server Versus Automation Client
Determining Automation Resource Requirements
Understanding the Big Picture
Creating and Setting a Reference to Another Application
Assigning an Object Variable to an Application
Creating an Instance of the Application
Using the Automation Object's Properties and Methods
Releasing the Automation Object
Putting It All Together
Closing the Automation Server Application
Using the UserControl Property to Determine How an Application Was Opened
Using WithEvents to Expose Events of the Automation Server
Using the Automation Tips and Techniques
Summary
Integrating with Microsoft Office
Why Integrate with Microsoft Office?
Use the Right Tool
Using the Macro Recorder to Write Code
Using Auto Macros
Microsoft Forms
Object Browser
Class Arguments for Office Applications
Automation Example
Automating Word
Automating Excel
Automating PowerPoint
Automating Outlook
Automating Graph
Summary
Using Visual Basic with Access
Creating ActiveX Code Components
Creating ActiveX Controls
Summary
Multiuser Issues
Multiple Users and Database Locking
Understanding Multiuser Issues
Reviewing Jet's Multiuser Design
Understanding Jet's Multiuser Locking
Selecting the Proper Architecture
Working With Locks
Optimizing Multiuser Applications
Oracle/SQL Server Locking
Summary
Security
Elements of Security
Workgroup Creation
Users and Groups
Implementing Security Using Startup Options
Security Concerns with Replication
Security for Split Databases
Security for Client/Server
Securing a Database Step by Step
Common Security Errors
Summary
Web Publishing with Access 2002
Configuring a Web Site for Web Publishing
Development Versus Production Environment
Choosing Your Platform
What Is the Option Pack?
Setting Up Your Web Server
Managing and Configuring Your Web Server
Securing Your Web Applications
What Is the Difference Between a Site and a Virtual Directory?
Summary
Web Enabling Access 2002 with Office Web Components
What Are the Office XP Web Components?
Using the Office Spreadsheet Control
Using the Office Chart Control
Using the Office PivotTable Control
Summary
Using Data Access Pages
Creating Your First Data Access Page
Implementing Interactive Drill-Downs
Incorporating the Office Web Components with DAPs
Scripting Data Access Pages
Summary
Web Publishing with Access 2002 and Active Server Pages
Using Active Server Pages
Understanding Active Server Pages
Getting Started with Active Server Pages
Active Server Pages 101
Real-Life Example: Establishing a Self-Maintaining Membership-Based Web Page
Access 2002 Web Publishing with XML
Creating Charts with the Chart Control
Summary
Index