Description
With more than 275 applied examples and 10 projects, Get right of entry to users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Get right of entry to Structured Question Language (SQL) and export/import Get right of entry to data to and from XML both manually and programmatically. The book, which covers the contemporary release of Get right of entry to and in advance versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, the usage of DDL, event programming, and the usage of ASP and XML. The text will show you methods to write and debug your programming code with the Visual Basic Editor; consider and use common VBA programming structures such as conditions, loops, arrays, and collections; code a “message box” and reprogram characteristics of a database; Question and manipulate your database from a Internet browser with Active Server Pages (ASP) and lots of more practical techniques.
Features: