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 https://www.youtube.com/watch?v=ywTfKmei5Qc How to Delete Duplicate Records in MS Access You are watching this video now! How to Add an Index to Your MS Access Table https://www.youtube.com/watch?v=A8-9erFqfkI How to Use Composite Keys in Microsoft Access https://www.youtube.com/watch?v=ZgzQfXHOiic How RDBMS Relationships Work https://www.youtube.com/watch?v=txQhw6Fk5MM How to use Transactions in MS Access - BeginTrans, Commit, Rollback https://www.youtube.com/watch?v=Rr4_XAabNFg How to Manually Enter Values into an Autonumber Field in MS Access https://www.youtube.com/watch?v=rJTRlNFu38k Replication in Microsoft Access https://www.youtube.com/watch?v=II268bWpD1c Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #duplicate #vba