:: Introduction
:: Database principles
:: Tables
:: Queries
:: Data security
:: Glossary
:: Resources
:: Student Files
:: Contact
:: Back to Main Site
:: Site Map

Microsoft Access - Class 2 - Part X

> Back

Index Properties

You can set the following index properties in the Index window :

Primary
The index is the primary key. Only one index can have this property.
Unique
Unique values must be entered in the field. This property is equivalent to selecting Yes (No Duplicates) when you create the index.
Ignore Nulls
Any records with a null value for the index expression will be excluded from this index.




Print this page

 

Copyright © 2006 Consultation SOS