Question about indexing fields (Access)

[Krass]

I have a very large table I want to speed up by using an index.

As my application shows the user the appointments of the day, the query gathering my information mainly uses the DATE in the WHERE/HAVING clause.

I've then created an index on the 'date' field.

My question is: my query is also having 3 or 4 more fields in the WHERE/HAVING clause. Are these fields slowing down the whole query because those aren't ALSO indexed? Even tho one of those is a boolean field and wouldn't deserve indexing.

Is one index sufficient?

Any important details to know like: is the field order in the WHERE clause important?... I made it so the first field is my 'date' (indexed) field. But I guess that was useless? Access would've automatically managed to use the indexed field?

I would tend to believe that. My table is like 150,000 records-long and the query will return a only 45-50 records-long recordset.

Just thought I'd ask you guys for your 2 cents... any comments greatly appreciated.