MS Access – How to optimize queries so the database runs faster This post lists common mistakes that lead to poor query performance. For this, we assume that you are using relational tables with primary keys, foreign keys, and indexes for the fields you are searching...