| |
| |
| 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 | |