O'Reilly logo

Access 2007 Programming by Example with VBA, XML, and ASP by Julitta Korol

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required