How To Get Pokemon Yellow On Iphone

indexes are part of the structure of the table, then define and change from the Table Design view.

• If the index is based on a single field.

Select the field and change the Indexed property.

If you click on the arrow on the right are three options:

* No, no index.

* Yes (Duplicates OK) defines an index that is duplicated in the table can have multiple rows with the same value in that column.

* Yes (No Duplicates) defines an index that is not duplicated in the table can not have two rows with the same value in that column.

• If the index is based on several fields.

We have to open the Indexes window by clicking the button that is on the Design tab:

Clicking on a window like this:

In the first column put the name of the index, in the second column the field name that is based on the index, and the third column we indicate the order (if you want the table rows are sorted in ascending or descending).

If the index is based on several columns put the name of the index in the first line with the first field that contains the following lines and indicated the other fields that make up the index.

The order may be different for each of the fields. Thus the index can be used to recover the data in alphabetical order by province and within province by town beginning with the letter z.

enough to define the index to perform the same operation to create fields, positioned in a row in the Index Name column, type the name of the index, go to the next column and write the name of the field or clicking on the right the field is the arrow that displays the list of fields that have the table to select the color, the same for the Order column (this column, as it only has two possible values \u200b\u200bby double-clicking moves from Ascending to Descending and vice versa)


At the bottom of the index have the properties:

• Principal: indicates whether the index is the primary key or not.

• Single: to indicate whether or not allow duplicate values. Only = Yes means that does not allow duplicate values.

• Ignore Nulls: if we put that together the rows that have null value in the field will be excluded from the index.

To modify indexes already defined or delete indexes or create new indices use the same mechanics as to create, delete and modify fields in a table.