Chapter 19Creating, Modifying, and Deleting Tables and Fields
In Part II of this book you tried out different methods that are available in Microsoft Office Access 2007 for creating and manipulating databases via VBA programming code using the DAO and ADO object models. In particular, you learned how to create new databases from scratch, add tables and indexes, set up relationships between tables, secure a database with a password, define user and group security accounts, and handle object permissions. In addition to using DAO and ADO, you can perform many of the mentioned database tasks by using the Data Definition Language (DDL), which is a component of the Structured Query Language (SQL).
SQL is a widely used language for data retrieval and ...
Get Access 2007 Programming by Example with VBA, XML, and ASP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
