How to Find Duplicates and Delete Them in Microsoft Access

In this Microsoft Access tutorial I'm going to teach you how to find duplicate records and delete them. I'll show you a manual process and then a different method to delete records in bulk.
LEARN MORE:
599cd.com/Find...
PRE-REQUISITES:
Backup Access: 599cd.com/Backup
LINKS:
Highlight Duplicates: 599cd.com/Dupl...
Prevent Duplicates: 599cd.com/Comp...
Append Query: 599cd.com/Append
RECOMMENDED COURSES:
Find Duplicates in Access Expert 18: 599cd.com/ACX18
Scrubbing Data in Access Developer 21: 599cd.com/ACD21
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Delete duplicate records, Finding and Removing Duplicate Records, Removing Duplicate Records

[@gonefishing2006]

Lifesaver.... because well I had an append query that ran repeatedly. In the end it looked like when I bought packages of baseball cards as a kid, 80 or so copies of the same card that nobody wanted. Now my table is smaller. Wish it was that easy to misplace weight.

[@prhggrl3110]

Sir u have solved my problem thanku ko so much

[@599CD]

You are very welcome

[@shahramahmadzadeh5285]

Excellent👍

[@599CD]

Thanks a lot

[@MeMotivate]

Hello sir, I have two tables. One is Students and the other is Cources. One single student has multiple cources and when i try to retrieve the the cources of one student the access brings all the cources with with repeated student data.. I mean 1 student has 5 cources. with every course, comes repeated student data. I need to select all the data from querry for Printing but i have to manually remove all the duplicate records that come with the course in excell or Word. Access is all good and great but this really annoys me sometimes. Please Help.

[@nancysterr0707]

I need a query or report that displays all exhibiting artists in a gallery. Each artist may submit more than one painting. I don’t want to remove any duplicates permanently. So… I may have 50 records but only 20 artists.

[@599CD]

I need...?

[@stephenbeswick2163]

Hi Richard could you please make a video on how to create a login screen in access for different uses my friend has had is database messed with even though I have had put a password in the database my friend is a none computer expert he needs things set out in front of him I have found that a login screen would be the best way for him can you help please.. I have acted several video bit I am a bit confused myself? Many thanks steveb

[@599CD]

599cd.com/Security

[@viktoriiayatsiuk7250]

Could you please help me, I need to create Gain and Loss Query in MS Access ( Access 2016). All the data looks correct, I checked for duplicates all tables there is none. But in my query where I put all data, there duplicates for each field. I have 9 fields, taken from different tables. And they all have duplicates. Please, help me delete these duplicates🙏

[@599CD]

599cd.com/ask

[@jimyeske8498]

Before I retired, I had to reconcile duplicates based on married name vs. maiden name. What a pain that was!

[@599CD]

I bet

[@GbSky5]

Cud not even create a simple playlist. Searching for old videos takes like forever 🤦

[@599CD]

Huh?