How to Delete Duplicate Records in MS Access

We all eventually end up working on some table that someone designed that has no primary key, and has tons of duplicates. Luckily, we can use a few powerful techniques to either get unique rows out of that table (1 of 2: extract), or we can use some coding techniques to use the power of sorting with the ability to look at previous and current rows to identify and delete problem rows (2 of 2: delete). The two techniques in this video are very powerful for data cleaning and wrangling, and will definitely help you in cases where uniqueness is a problem in the data. Related Videos: How to Cycle Through Many TableDefs to Rename or Delete Many Tables in MS Access    • How to Cycle Through Many TableDefs to Ren...   How to Delete Duplicate Records in MS Access You are watching this video now! How to Add an Index to Your MS Access Table    • How to Add an Index to Your MS Access Table   How to Use Composite Keys in Microsoft Access    • How to Use Composite Keys in Microsoft Access   How RDBMS Relationships Work    • How RDBMS Relationships Work   How to use Transactions in MS Access - BeginTrans, Commit, Rollback    • How to use Transactions in MS Access - Beg...   How to Manually Enter Values into an Autonumber Field in MS Access    • How to Manually Enter Values into an Auton...   Replication in Microsoft Access    • Replication in Microsoft Access   Find me on Patreon :   / mackenziedataengineering   Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-... Avoid hidden costs and complexity. Get Virtual machines, S3 storage, and more, on your own cloud network. https://beaverdamtechnologies.ca Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects... Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media:   / mackenziedataanalytics     / seamacke     / seamacke     / seamacke     / psmackenzie   Thank you to my viewers! Mention Promo Code SMDE25TWELVE for 25% off a twelve-month virtual machine subscription at: https://beaverdamtechnologies.ca Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenz... #msaccess #duplicate #vba