Microsoft? Access? 2010 Programming By Example: with VBA, XML, and ASP

Microsoft? Access? 2010 Programming By Example: with VBA, XML, and ASP

5.0 1
by Julitta Korol
     
 

With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL), and export/import Access data to and from XML both manually and programmatically.

The book, which covers the latest release of Access and earlier versions,

…  See more details below

Overview

With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL), and export/import Access data to and from XML both manually and programmatically.

The book, which covers the latest release of Access and earlier versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. The text will show you how to write and debug your programming code with the Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a “message box” and reprogram characteristics of a database; query and manipulate your database from a Web browser with Active Server Pages (ASP) and many more practical techniques.

Editorial Reviews

From the Publisher
This practical how-to manual for programming in Access 2010 using VBA XML and ASP introduces concepts with multi-step, illustrated, and hands-on exercises with 275 applied examples and 10 projects designed to let the reader quickly build solutions using Data Access Objects (DAO), ActiveX Data Objects (ADO) and SQL. 33 chapters progressively introduce concepts that build on skills used in previous chapters to use both the latest version of Access as well as earlier versions to integrate Access with web displays, import data and to write and debug queries, routines and functions. Other topics include templates, macros and customizing interfaces. The guide includes a CD-ROM with source code and supplemental files for projects.

Product Details

ISBN-13:
9781936420025
Publisher:
Mercury Learning and Information
Publication date:
02/28/2012
Pages:
800
Sales rank:
475,252
Product dimensions:
7.00(w) x 8.90(h) x 1.60(d)

Related Subjects

Meet the Author

Julitta Korol is a software consultant who delivers custom-tailored hands-on training and develops advanced database and spreadsheet applications. She has written over 20 computer books. She lives on Long Island, New York.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft Access 2010 Programming By Example: With Vba, Xml, And Asp 5 out of 5 based on 0 ratings. 1 reviews.
SeabrookMLM More than 1 year ago
I have been building applications in Access for 12 years, and I found this book to be an excellent reference and addition to what I have learned on my own. Not only does it cover the basics, but I especially appreciate that it does an in-depth introduction to newer subjects such as ribbon customization, class modules, XML features. This is not a rehash of an old book but a most current resource. Indispensable reference if you want to write systems for general use.