Category Archives: Microsoft Access 2016

Creating a custom sort in Microsoft Access

It is easy enough to do a custom sort in Microsoft Excel, but what about in Access. In Access, you can create a calculated field using IIf in order to be able to do so. As an example, if you … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 4 Comments

Microsoft Access – finding duplicate records

If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find records with the same … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 1 Comment

Using a crosstab query to summarize data in Microsoft Access

If we need to summarise data such as products sold per region, we can do this by using a crosstab query which will allow us to use data from more than one table. You can create a crosstab query by … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | Leave a comment

Using the keyboard to navigate records in Microsoft Access datasheet view

Keystroke Effect ↓ Go to the next record ↑ Go to the previous record Ctrl + End Go to the last field in the last record Ctrl + Home Go to the first field in the first record → or … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | Leave a comment