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 12Setting Up Primary Keys, Indexes, and Table Relationships

After defining the fields for your tables, take the time to define primary keys, indexes, and relationships between tables. This chapter focuses on the DAO and ADOX objects that are designed to work with these features.

Creating a Primary Key Index

Indexes determine the order of records accessed from database tables and whether or not duplicate records are accepted. While indexes can speed up access to specific records in large tables, too many indexes can also slow down updates to the database. Each table in your database should include a field (or set of fields) that uniquely identifies each individual record in a table. Such a field or set of fields is called a primary key ...

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