EAN: 9781936420025

MICROSOFT® ACCESS® 2010 PROGRAMMING BY EXAMPLE ...

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  and  query and manipulate your database from a Web
browser with Active Server Pages (ASP) and many more practical techniques. There are thirty-two
chapters loaded with illustrated hands-on projects and exercises that demonstrate programming
concepts. Each exercise project tells you exactly where to enter code and how to debug it and
then run it. This title includes a comprehensive CD-ROM with tips  shortcuts  and tutorials. It
is updated for Access 2010 and based on the bestselling editions from previous versions. Store
data for further manipulation in variables  arrays  and collections  write simple and complex
VBA programming routines and functions. Create custom database forms  reports  and details on
controlling and customizing the Ribbon. Use DAO and ADO methods to access and manipulate
database records (insert  update  and delete data via code)  work with Access database files
in.MDB and.ACCDB formats. Use external data sources with Access (SQL Server  flat files  Excel
Word  and XML) and generate dynamic XML and ASP documents from any Access database and display
data on the Web.

Aktuelle Preise zur EAN 9781936420025

Produktinformationen zur 9781936420025