benefit of using Index field

[Shella]

As we can create single-field index and multifield index in a database, I'm not aware of the benefit of using Index for a field except in preventing the occurence of the same field or the same group of fields in a table (Like Primary key, or Unique Grouped Fields ). How can an Index speed up the sorting and searching when I use findfirst method in VB thru given example ? Thanks