Access 2003 Programming by Example with VBA, XML, and ASP

Author:
Julitta Korol
Format:
Softcover

Out of stock

United States of America


Access 2003 Programming by Example with VBA, XML, and ASP Out of stock

Short description

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions.

Long description

The latest release of the Microsoft Office family of applications comes with many bells and whistles. Access continues to be the world's most popular database. With the increasing volume of information, knowing how to design and program databases is becoming more and more important. With most users having mastered the use of Access databases, this book is designed to take them to the next step -- programming. "Access 2003 Programming by Example with VBA, ASP and XML" takes non-programmers through detailed steps of creating Access databases from scratch and then to retrieve and manage their data using various programming languages and techniques. With this book at hand, users can quickly build the toolset required for developing their own database solutions. This book proves that programming Access databases and controlling it with various types of programming code can be as easy as working with the built-in user interface. The book offers more hands-on and custom projects than any other book ever published on Access programming. It consists of six parts that cover an introduction to VBA programming, using ActiveX Data Objects (ADO), Data Definition Language (DDL), event programming, Active Server Pages (ASP), and Extensible Markup Language (XML). The downloadable companion files include all the book's projects as well as a PDF file that covers creating and manipulating databases using Data Access Objects (DAO), an older data access technology that Access still uses.

Product details

Publisher:
Jones & Bartlett Publishers
ISBN:
9781556222238
Publication date:
January 2005
Length:
233mm
Width:
154mm
Thickness:
36mm
Weight:
930g
Pages:
704
Illustrations:
Illustrated
Readership:
General

Table of contents

  • Procedures and Modules
  • The Visual Basic Editor (VBE)
  • Variables, Data Types and Constants
  • Passing Arguments to Procedures and Functions
  • Decision Making with VBA
  • Repeating Actions in VBA
  • Working with Arrays
  • Custom Collections and Class Modules
  • Debugging VBA Procedures and Handling Errors
  • Accessing Data Using ADO
  • Creating and Accessing Tables and Fields with ADO
  • Setting Up Indexes and table Relationships with ADO
  • ADO Techniques for Finding and Reading Records
  • Working with Records
  • Creating and Running Queries with ADO
  • Using Advanced ADO Features
  • Database Replication
  • Creating, Modifying and Deleting Tables and Fields
  • Enforcing Data Integrity and Relationships Between Tables
  • Defining Indexes and primary Keys
  • Database Security
  • Viewed and Stored Procedures
  • Using Form Events
  • Using Report Events
  • Events Recognised by Controls
  • Access and Active Server Pages
  • XML Features in Access 2003
  • Index.

Other products to consider

Beginning Access 2003 VBA
Beginning Access 2003 VBA

Author:
Denise Gosnell
Now R320.95
(eB 3210)
Access VBA Programming
Access VBA Programming

Author:
Charles E. Brown; Ron Petrusha
Now R387.95
(eB 3880)
Banking for the new millennium: (1ST - 1999)
Banking for the new millennium: (1ST - 1999)

Author:
A. Pampalis; A. Van Der Merwe; L. Mdluli; W. Goosen
Now R241.95
(eB 2420)
Access 2003 VBA Programmer's Reference
Access 2003 VBA Programmer's Reference

Author:
Armen Stein; Patricia Cardoza
Now R320.95
(eB 3210)

Out of stock

Access 2003 Programming by Example with VBA, XML, and ASP

Access 2003 Programming by Example with VBA, XML, and ASP

In my basket
Your basket is empty
Free delivery on orders over R250 *
 
My wishlists
Your wishlist is empty
Earn with Visa
 
eBucks
 
m.kalahari.com
 
Become a corporate client with kalahari.com
 
Book donation project