Selecting indexes (in Access)

Hey all,

I was hoping I could gather some resources/articles/documents/etc. on index selection methodologies in DBMS systems. I'm using Access 2000 for a fairly large project and I'm trying to do my best to select my indexes wisely.

I understand what indexes are, and the basic idea behind selecting indexes, but I was hoping to further this understanding, especially as it pertains to Access. Any links you might have on indexing in Access, or even generic methods in 'x' DBMS, or just thoughts on the subject would be helpful. My hope is that I can reduce overhead and speed up concurrent access by doing my index selection right, the first time.

Thanks :)