Lesson 3

What are indexes? What are the advantages and disadvantages of using indexes?

A. Indexes sort on certain field that you will be searching for. This enables quicker searches. A disadvantage might be that you can't index on an OLE field.

What is referential integrity and why is it important to your Access database?

A. Referential integrity helps prevent loose ends. In my database, there cannot be a Beginning Teacher without an assigned mentor.