So you have a database of information in Microsoft Access, however when it comes to queries it can perform poorly. The 3 tips listed below will help you better optimise your database and improve query performance.

1. Regular Compaction of Database.

When you compact your database, the records contained in that database are reorganised next to one another, getting rid of any empty space in-between them. This in turn makes the retrieval of data and query results faster.

2. Limit the number of fields returned by a query.

Limiting the number of fields a query returns drastically affects the performance by making it faster and also uses fewer resources.

3. Give the search engine less evaluations to carry out.

You can do this by using Between instead of => and <=. By using Between, you are only asking the search engine to carry out one evaluation rather than two.

Want more tips for Microsoft Access? Visit our Access Hints and Tips page.

Are you interested in learning more about Microsoft Access? Then you should book yourself on one of our Microsoft Access Training Courses.