With the data in Power Query, it’s time to find the duplicates. There are two duplicate rows, which you can easily find by sorting, but you don’t have to sort when using Power Query.

Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily.