DAO Object Model: The Definitive Reference [Illustrated] (Paperback)

Though the book is written primarily from the viewpoint of Access and Excel VBA, it doesn't neglect those using one of the other varieties of VBA or Outlook VB Scripting, or even Windows Scripting Host. The accompanying CD-ROM contains a very useful program, Object Model Browser, which views an object graphically, making it significantly easier to see in context how an object interfaces hierarchically with the Model. All the code examples can also be found on the CD-ROM.

The writing style is crisp and economical yet complete and readily understandable. In tricky places, text is well supplemented with practical examples. Though a fair working knowledge of VBA is required to get the most out of this volume, it can be picked up and used by programmers at any level of experience, and should serve as a useful long-term distillation of what you need to know to personalise Microsoft applications effectively. --Wilf Hey

Product Description
Each iteration of Windows has meant a corresponding improvement in the techniques used for transferring data among its applications. Today's leading technique is called Automation. It allows you to work directly with objects in an application's interface using their object models. But if you want to write code in a programming language, such as Visual Basic, in order to work with the apps that support Automation, you must understand the inner workings of an application's object model--or in the case of Microsoft's Access, its two-object models. Microsoft Access is the bestselling stand-alone relational database program for Windows offering both power and ease of use. And in many respects, Microsoft has made Automation the centerpiece of its vision for application development. DAO Object Model: The Definitive Reference will guide you through the Access object models, allowing you, with the support of Automation, to reference the application components you want to manipulate. An understanding of the object models is essential for developers who work with data in Access tables, or who want to manipulate components of the Access interface from other Office apps. The Data Access Objects (DAO) model is used to write and read data in Access tables. The Access object model is used to manipulate forms, reports, queries, macros, and other components of the Access interface, including most of the commands by means of the DoCmd object. This book includes an introduction and a brief description of the differences between VBA (used in most Office applications) and VBScript (used in Outlook). This chapter will also cover Office utilities and add-ons helpful in writing and debugging code, such as the Object Browser, the Integrated Development Environment (IDE) for VBA and the Interactive Debugger for VBScript. The book will then be divided into two parts; one covering the Access Object Model and the other, the Data Access Objects. Each section will have a description of what the object represents; listings of properties, events, and methods; and one or more code samples illustrating its use in VBA and/or VBScript code. Each property, event, or method section will have an explanation of the language element, and many will have code samples (either VBA or VBScript) as well. The book details, to an advanced user or keen intermediate user, the Access object models and how they are used.

See all Product Description

• Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
• Books > Computing & Internet > Databases > Database Modelling
• Books > Computing & Internet > Programming > Languages & Tools
• Books > Computing & Internet > Programming > Languages > Visual Basic
• Books > Study Books > FE & College > Vocational > Sport & Recreation

• Would you like to update product info or give feedback on images?
• I am the Author, and I want to comment on my book.
• I am the Publisher, and I want to comment on this book.