Chapter Summary

In this chapter, you learned how to enforce data integrity by creating rules for tables with constraints. You learned how to validate data against another column in the same table or a column located in another table. You also learned how to use the Access Data Definition Query window to delete tables that have constraints and remove constraints from a table. Finally, you saw how you can establish relationships between tables using the DDL commands inside your VBA procedures.

In addition, one of the procedures in this chapter introduced you to a couple of advanced Data Manipulation Language (DML) statements used for inserting data into tables and executing transactions.

The next chapter focuses on ways to use DDL for defining and removing indexes and primary keys.

Defining Indexes and Primary Keys

Indexes speed the processes of finding and sorting records. You should create indexes for fields that are frequently used in searches and in sorting. You can create an index on a new or existing table. An index can be made of one or more fields. This chapter presents a number of procedures that use Data Definition Language statements to define indexes and primary keys.

0 0

Post a comment