Expert Instruction. Advanced Coverage. An Unbeatable Price. This two-volume set provides you with the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, covering the full range of Access desktop and enterprise applications. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books provide the skills you need to be a professional Access developer. Access 2002 Desktop Developer's Handbook Design and Build Access Databases for Single Users and Small Workgroups Design Forms and Reports That Meet Users' Exact Needs Take Full Advantage of the Latest Access Functionality, Including New PivotTable and Pivot Chart Views and New Programmability Features Access 2002 Enterprise Developer's Handbook Publish Data on the Web with Data Access Pages Take Advantage of Improved SQL Server Integration and XML Support Tackle the Toughest Replication and Security Challenges Put the New Office Web Components to Work in Your Access Applications

DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET TRUE ENTERPRISE NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Enterprise Developer's Handbook offers complete coverage of every aspect of building client-server Access applications for large-scale enterprises. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage Includes: * Developing Access projects that store data using SQL Server * Managing concurrency using stored procedures * Creating data access pages that allow the editing and viewing of Access and SQL Server data in a browser * Using data access pages to validate data, link pages, and create dynamic HTML effects * Retrieving and editing server data directly with ADO * Managing multiple developers with source code control * Creating Web pages that connect to Access and SQL Server data * Controlling all aspects of replication * Securing your Access databases and projects * Distributing your Access applications * Importing and exporting XML files * Creating and managing SQL Server objects

DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET YOUR ORGANIZATION'S SPECIAL NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Desktop Developer's Handbook offers complete coverage of every aspect of building Access applications for single users and small workgroups. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage includes * Understanding the Access event model * Using VBA class modules * Applying sound database design principles * Using Access SQL * Controlling controls * Using ActiveX Data Objects (ADO) * Designing effective forms and reports * Taking advantage of shared Office programmability * Controlling your printer * Using Access as an automation client and server * Debugging and handling errors * Optimizing your application * Accessing DLLs and the Windows API * Adding professional features offered by Access Wizards * Building COM add-ins and MDA files * Using Reddick VBA naming conventions

This how-to book of custom applications shows how organizations can use Access 97 to develop effective information systems in less time, for less money. This is the one-volume reference that shows users how to automate tasks, do application programming, and integrate an Intranet or the Internet. The CD includes source files and developer tools.

HTTP is the protocol that powers the Web. As Web applications become more sophisticated, and as emerging technologies continue to rely heavily on HTTP, understanding this protocol is becoming more and more essential for professional Web developers. By learning HTTP protocol, Web developers gain a deeper understanding of the Web's architecture and can create even better Web applications that are more reliable, faster, and more secure. The HTTP Developer's Handbook is written specifically for Web developers. It begins by introducing the protocol and explaining it in a straightforward manner. It then illustrates how to leverage this information to improve applications. Extensive information and examples are given covering a wide variety of issues, such as state and session management, caching, SSL, software architecture, and application security.

How Far Can You Go with Access 2002? The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes * Running queries to find specific records * Automating complex and time-consuming procedures * Importing data from existing data sources * Synchronizing forms and tables * Understanding the ADO and DAO models * Understanding the essentials of Visual Basic for Applications (VBA) * Customizing the Access user interface * Creating procedures to change Access's default error-handling processes * Accessing data using OLE DB and ODBC * Creating VBA procedures for navigating a database or project * Writing VBA procedures using object properties and methods * Creating relationships between forms * Executing commands using SQL statements in VBA code * Using ActiveX controls in your VBA procedures