How Do You Determine Which Primary Key Type To Use In Access 2003?
Microsoft Access 2003 allows for the management and interpretation of large databases, but only if you are able to use its tools effectively. By assigning the correct primary key type, you can use Microsoft Access 2003 to locate and group data according to one of the three key types, or specific field in your table. Here is how to determine which primary key type to use in Access 2003. Decide which key type you want to use. There are three primary key types: AutoNumber, single-field and multi-field. Select multi-field for working with data that has relationships based on multiple criteria. An example of this might be customers who live in the tri-state area that have not paid their bills. Use the single-field primary key if your relationships are in a single dimension (customers who live in a particular area). Use the AutoNumber primary key when you want the quick and dirty version. This feature assigns a number to each record in your database. Set or change the primary key by clicking
