Is there a way to find and remove duplicate entries in tables by using queries.....if so, how specifically?

there is a duplicate query option in the query design wizard. it will allow you to find the duplicates and delete one of them, if you wanted this to be automated, you would have to run a delete query to delete only one of the records