Sunday, 14 February 2010

This database contains various examples of Data Definition Language (DDL) and Data Manipulation Language (DML) of both DAO and SQL.


The examples here were taken largely (though not completely) from "Access Database Design && Programming" by Steven Roman and published by O'Reilly.
There are 5 modules:
Class 10: Shows general examples of Data Access Objects (DAO)
Class 11: Illustrates DAO DDL techniques
Class 12: Illustrates DAO DML techniques
Class 13: Shows how to use embedded SQL DDL
Class 14: Shows how to use embedded SQL DML

Download

Access 97 (101 KB): Dao97.zip

Access 2000 DAO (144 KB): DAO2k.zip
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Receipt Management: Stop Losing Paper Receipts Forever

Paper receipts fade, tear, and get lost. Here's how the Petty Cash app solves the receipt problem permanently. The Paper Problem Therma...

  • AppendValuesToExcel.mdb (intermediate)
    This sample demonstrates how to append data from a database to an Excel Spreadsheet using Office Automation to find the next empty row in th...
  • Microsoft Office Access 2007
    Microsoft Office Access , previously known as Microsoft Access , is a relational database management system from Microsoft that combines t...