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...

  • Project management Essay
    Project management Essay  Lets discuss about project management ,  the project management is Skills and techniques,  project management sk...
  • ActionQueriesInCode.mdb (beginner)
    ActionQueriesInCode.mdb (beginner) There are a variety of circumstances under which you might want to run a query in VBA code. You may ...