{"id":58,"date":"2025-04-30T10:31:11","date_gmt":"2025-04-30T10:31:11","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=58"},"modified":"2025-05-03T18:40:16","modified_gmt":"2025-05-03T18:40:16","slug":"removing-duplicate-records-in-microsoft-access","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access","title":{"rendered":"How to Remove Duplicates in Access 2013\/2016\/2019?"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Duplicate data often arises when multiple users enter data into the database simultaneously or if the database was not designed to check for duplicates.\u00a0<span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">The easiest way to\u00a0<strong>remove duplicate access<\/strong><\/span>\u00a0records is by making use of the query. This post describes <strong>how to remove duplicates in Access<\/strong> with ease.<!--more--><\/p>\n<p>Let&#8217;s know how it is to be done&#8230;!<\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h2 style=\"text-align: left;\"><strong>What Is A Duplicate Data?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Data is called duplicate data when it is an exact copy of another dataset or gives the same information as the other dataset.<\/p>\n<h4 style=\"text-align: justify;\"><strong><em>Duplicate data occurs at different levels:<\/em><\/strong><\/h4>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\"><strong>More than two records containing duplicate field: <\/strong>Records can be considered duplicates when some of the fields have matching values. For Example, if two fields are entered with the same Customer ID, then it will be considered as a duplicate record.<\/li>\n<li style=\"text-align: left;\"><strong>More than two tables containing similar data: <\/strong>In some cases, say, there are two tables, one of Customer and the other of the client, both have records of the same customer, so duplicacy can be removed by merging the two tables into a single table.<\/li>\n<li style=\"text-align: left;\"><strong>More than two databases containing similar data: <\/strong>More than two databases containing similar data, or the database is assumed to be overlapping the current database, and then each database needs to be compared, which is not an easy task. But with the help of third-party vendors, tools can be used to compare the structure and contents of the database.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-60\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/images.png\" alt=\"Duplicate Record\" width=\"373\" height=\"210\" \/><\/p>\n<h2 style=\"text-align: left;\"><strong>Which Data Is Not Considered Duplicate Data?<\/strong><\/h2>\n<ol>\n<li style=\"text-align: left;\">In some cases, more than two records show the same value but do not refer to the same thing. For Example, say <strong>many customers<\/strong> have the name <strong>Steve Smith<\/strong>, but actually they <strong>all are different people<\/strong>. As they will have different Customer IDs, addresses, etc.<\/li>\n<li>Data returned in a Query resembles having duplicate records, because it does not specify the unique identity of each record. But by the same Query by <strong>primary key field<\/strong>, it will show records uniquely.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-65\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/DuplicateRows.png\" alt=\"Duplicacy of records\" width=\"461\" height=\"318\" \/><\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>How to Find Duplicate Records In Access?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">You can <strong><a href=\"https:\/\/support.office.com\/en-us\/article\/Find-duplicate-records-with-a-query-3cc805a2-2a13-4439-b0d3-6b23c7d60fbb\">find the duplicate records<\/a><\/strong> using the Query Wizard, and the steps to do so are as follows:<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">On the<strong> Create<\/strong> tab, from the<strong> Queries<\/strong> group, click <strong>Query Wizard<\/strong>.<\/li>\n<li style=\"text-align: left;\">In the new query dialog box, tap to <strong>Find Duplicate Query Wizard<\/strong> option and then click<strong> Ok<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-63276\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-1.jpg\" alt=\"\" width=\"542\" height=\"375\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-1.jpg 542w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-1-300x208.jpg 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/p>\n<p>3. From the list of tables, choose the appropriate table of your use and then click to the<strong> Next<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-63277\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-2.jpg\" alt=\"\" width=\"543\" height=\"375\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-2.jpg 543w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-2-300x207.jpg 300w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><\/p>\n<p style=\"text-align: justify;\">4. Select the fields you want to match with and then click to the <strong>Next<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-63278\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-3.jpg\" alt=\"\" width=\"542\" height=\"375\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-3.jpg 542w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-3-300x208.jpg 300w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><\/p>\n<p style=\"text-align: justify;\">5. From the available field list, select for the field that contains the data that you want to update and click to <strong>Next<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-63279\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-4.jpg\" alt=\"\" width=\"543\" height=\"373\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-4.jpg 543w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-4-300x206.jpg 300w\" sizes=\"auto, (max-width: 543px) 100vw, 543px\" \/><\/p>\n<p style=\"text-align: justify;\">6. Accept the suggested query name or assign any name and then click to the <strong>Finish <\/strong>option to run the query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-63275\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-5.jpg\" alt=\"\" width=\"600\" height=\"151\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-5.jpg 600w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/finding-duplicate-records-5-300x76.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong>Also Read: <\/strong><strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/access-ldb-or-laccdb-file-unlock\">How To Unlock Or Remove Access Database LDB\/LACCDB File?<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>How To Resolve And Prevent Duplicacy Of Data In Access?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Data duplication in the table generally arises because of overlapping records. The following steps are required to be followed in order to <strong>remove duplicate Access <\/strong>records.<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"text-align: left;\">The query must show the records of the table that overlap. It can be done by sorting the records by field.<\/li>\n<li style=\"text-align: left;\">A distinct entity of a duplicate record can be edited.<\/li>\n<li style=\"text-align: left;\">If there is another record of the same entity, then duplicate records can be deleted.<\/li>\n<li style=\"text-align: left;\">It might also happen that one duplicate data is deleted and the other is edited. Then the deleted record from the table must be cascaded to the other table.<\/li>\n<li style=\"text-align: left;\">Each and every table should have a <strong>Primary key.<\/strong><\/li>\n<li style=\"text-align: left;\">If fields do not have a Primary Key, then they should have unique indexes, unique values for the fields.<\/li>\n<li style=\"text-align: left;\">To find existing values easily by using a list box and creating a data input.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>How To Delete Duplicate Records In Access?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Here are the complete steps on how to create and run a delete <a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/fixes-for-various-access-query-errors\"><strong>query in Access 2013\/2016<\/strong><\/a>.<\/p>\n<ol>\n<li style=\"text-align: left;\">Go to the <strong>query designing<\/strong> group and click the <strong>create<\/strong> tab. Now, in the<strong> show table<\/strong> dialog box, double click the table from which you want to delete your records.<\/li>\n<li style=\"text-align: left;\">Make a double-tap on the<strong> asterisks (*)<\/strong> to add all the table fields to the query designer.<\/li>\n<li style=\"text-align: left;\">Simply add the fields that you have kept to identify the records for deletion.<\/li>\n<li style=\"text-align: left;\">You can also put criteria in the <strong>Criteria Row<\/strong>.<\/li>\n<li style=\"text-align: left;\">Clear the<strong> Show<\/strong> checkbox for each criteria field.<\/li>\n<li style=\"text-align: left;\">From the <strong>Design<\/strong> tab, click <strong>Run<\/strong>. Verify that the query returns the records that you want to delete.<\/li>\n<li style=\"text-align: left;\">From the<strong> Design<\/strong> tab click the <strong>Design<\/strong> tab and then the<strong> Delete<\/strong> Access will change the select query to a delete query, hides the Show row in the lower section of the design grid, and adds the<strong> Delete <\/strong>row.<\/li>\n<li style=\"text-align: left;\">One more verification required that is before you run the delete query, make sure that the delete row in the\u00a0<strong>*<\/strong>(all fields) column displays\u00a0<strong>From\u00a0<\/strong>and\u00a0<strong>Where<\/strong> must appear in any of the criteria columns.<\/li>\n<li style=\"text-align: left;\">At last, on the <strong>Design<\/strong> tab, click <strong>Run&gt;Yes<\/strong>.<\/li>\n<\/ol>\n<h2 style=\"margin-top: 0in; background: white; text-align: left;\"><strong><span style=\"color: #000000;\"><span style=\"font-family: Arial, sans-serif;\">How to Recover Deleted Records From MS Access Database?<\/span><\/span><\/strong><\/h2>\n<p style=\"text-align: justify;\">Sometimes, a situation also happens that while <strong>deleting the Access Duplicate Records<\/strong>, accidentally both the actual and duplicate files get deleted. Then, at times, what will be your step? How can you get it back?<\/p>\n<p style=\"text-align: justify;\">Feeling frustrated, well, no need for that \u2026!<\/p>\n<p style=\"text-align: justify;\">You can easily delete records in Access by using the <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool\" target=\"_blank\" rel=\"noopener noreferrer\">Access Repair and Recovery Tool<\/a>. <\/strong>This software is used to <strong><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/repair-and-restore-partial-corrupted-mdb-access-file\">recover damaged, corrupt, or inaccessible databases<\/a><\/strong>. It easily recovers the database from any sort of corruption. It can restore corrupt relations, queries, tables, and indexes.<\/p>\n<center><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2020\/06\/en-dwn-btn.jpg' \/><\/a><p style='font-size:11px;'><font color='red'><b>*<\/b><\/font> By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/p><\/center>\n<p style=\"text-align: justify;\">This tool can even recover password-protected modules or forms. It&#8217;s advantageous for small, mid-size enterprises and for individual businesses to run and maintain their database. This tool helps in building forms, reports, tables, and queries.<\/p>\n<h3 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Step By Step Guide On How To Retrieve Deleted Records In Microsoft Access<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><\/span><\/p>\n<h2 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Precautions To Be \u00a0Followed Before Deleting Duplicate Data<\/strong><\/span><\/h2>\n<ol>\n<li style=\"text-align: left;\">The database file should not be read-only.<\/li>\n<li style=\"text-align: left;\">Only one person should work on the database at a time, which reduces data conflict.<\/li>\n<li style=\"text-align: left;\">One must open the database in exclusive mode by clicking the <strong>File tab<\/strong>, then <strong>Open<\/strong>, clicking the arrow next to <strong>Open<\/strong> button, and selecting <strong>Open Exclusive.<\/strong><\/li>\n<li style=\"text-align: left;\">The database must be <strong>backed up<\/strong> before <strong>deleting records<\/strong>.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Is There a Formula to Remove Duplicates?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Yes, you can use the UNIQUE() function in MS Access or similar formulas to show unique values in real time as data changes.<\/p>\n<h4 style=\"text-align: left;\"><strong>Why Remove Duplicates?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Duplicate records can impact the quality of your database data, bias prediction results, and waste storage space. Removing such duplicates confirms that each value is unique and correctly represents your data.<\/p>\n<h4 style=\"text-align: left;\"><strong>Which Command Is Used to Remove Duplicate Records?<\/strong><\/h4>\n<p style=\"text-align: justify;\">By using the DISTINCT command, you can delete duplicate records. However, you can select only unique rows &amp; then insert them back into the original table, efficiently deleting duplicates.<\/p>\n<h4 style=\"text-align: left;\"><strong>What Is the Shortcut Key for Duplicates?<\/strong><\/h4>\n<p>After selecting CTRL+A, you can use the shortcut keys in this sequence: <strong>Alt + H + L + H + D<\/strong>.<\/p>\n<h2 style=\"text-align: left;\"><strong>Final Verdict<\/strong><\/h2>\n<p style=\"text-align: justify;\">Duplicate records slow down performance and impact data quality. With Access tools like queries, indexing, and VBA, managing them becomes easy. Stay organized, and your database will remain efficient and accurate.<\/p>\n<p>Moreover, if you find any difficulty meanwhile this process of removing<strong>\u00a0duplicates Access <\/strong>records process then share your problem with us on our <strong><a href=\"https:\/\/www.facebook.com\/pages\/MS-Access-Repair-Tool\/635545369889347\" target=\"_blank\" rel=\"noopener\">Facebook<\/a><\/strong> and <a href=\"https:\/\/twitter.com\/accessrepair1\" target=\"_blank\" rel=\"noopener\"><strong>Twitter<\/strong><\/a>\u00a0social accounts.<\/p>\n<p>I hope you liked this post!<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Duplicate data often arises when multiple users enter data into the database simultaneously or if the database was not designed &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Remove Duplicates in Access 2013\/2016\/2019?\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#more-58\" aria-label=\"Read more about How to Remove Duplicates in Access 2013\/2016\/2019?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":66147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1979,1981,1980],"class_list":["post-58","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-how-to-remove-duplicates-in-access","tag-how-to-remove-duplicates-in-ms-access","tag-ms-access-remove-duplicates","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Remove Duplicates in Access 2013\/2016\/2019?<\/title>\n<meta name=\"description\" content=\"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Remove Duplicates in Access 2013\/2016\/2019?\" \/>\n<meta property=\"og:description\" content=\"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-30T10:31:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-03T18:40:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"How to Remove Duplicates in Access 2013\/2016\/2019?\",\"datePublished\":\"2025-04-30T10:31:11+00:00\",\"dateModified\":\"2025-05-03T18:40:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\"},\"wordCount\":1237,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg\",\"keywords\":[\"how to remove duplicates in Access\",\"how to remove duplicates in MS Access\",\"MS Access remove duplicates\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\",\"name\":\"How to Remove Duplicates in Access 2013\/2016\/2019?\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg\",\"datePublished\":\"2025-04-30T10:31:11+00:00\",\"dateModified\":\"2025-05-03T18:40:16+00:00\",\"description\":\"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg\",\"width\":960,\"height\":540,\"caption\":\"How To Find And Remove Duplicate MS Access Records\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Remove Duplicates in Access 2013\/2016\/2019?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Remove Duplicates in Access 2013\/2016\/2019?","description":"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access","og_locale":"en_US","og_type":"article","og_title":"How to Remove Duplicates in Access 2013\/2016\/2019?","og_description":"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2025-04-30T10:31:11+00:00","article_modified_time":"2025-05-03T18:40:16+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg","type":"image\/jpeg"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"How to Remove Duplicates in Access 2013\/2016\/2019?","datePublished":"2025-04-30T10:31:11+00:00","dateModified":"2025-05-03T18:40:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access"},"wordCount":1237,"commentCount":0,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg","keywords":["how to remove duplicates in Access","how to remove duplicates in MS Access","MS Access remove duplicates"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access","name":"How to Remove Duplicates in Access 2013\/2016\/2019?","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg","datePublished":"2025-04-30T10:31:11+00:00","dateModified":"2025-05-03T18:40:16+00:00","description":"Catch complete detail on how to remove duplicates in Access. Also, learn the precautionary tips to be taken to avoid duplicates in Access database.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2015\/06\/Find-And-Remove-Duplicate-MS-Access-Records-.jpg","width":960,"height":540,"caption":"How To Find And Remove Duplicate MS Access Records"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/removing-duplicate-records-in-microsoft-access#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Remove Duplicates in Access 2013\/2016\/2019?"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":3,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":69031,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/58\/revisions\/69031"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/66147"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}