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-...



Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

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  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #duplicate #vba