When you are designing and maintaining your database then you can spend time to avoid data duplication. You get or gather duplicate data very often despite of solid design or documentation. If the database is used by several people then it may gather duplicate data. Duplicate data in a database is very confusing and it sometimes leads to a lot of wasted time and effort.

You can easily find and check for duplicates in MS Access.


If two or more records contain values that wholly or partially match in one or more fields in a table then they can be duplicates. It is not necessary to match all the fields because only two records can be considered as duplicates.


There are duplicates if all fields displayed in a view contain matching values for two or more records. There can be one situation like you might see duplicate records, even though the underlying tables seem to contain only unique records. If your view does not include the fields that could uniquely identify a record then you can come across to some problems.


If two or more tables in the database contain similar data then they are duplicate data. You can see in some database that it has two tables and for some data, records exist in both tables. So this is the case where it appears to be a case where two tables contain the same kind of information. In this case you have to avoid duplicate data and have to do some clean up.


There are duplicate data if two or more database contains similar data. You should know that duplication can occur at the database level. Check whether two or more databases contain similar data then you have to compare the data and structure of the databases. You may also inherit a database that overlap with your current database then it is very important to take some necessary steps to avoid these duplicate data.

You can also use the wizard in the MS Access to check for duplicate data. First step is to open the database window then click the queries tab. Now you just have to click new then new query dialogue box will open. After that click find duplicate query wizard and press ok. Now you just have to follow the instruction given by the wizard and finish the checking of duplicate queries. When all the information is entered; press finish. You can also view your queries.

While doing all these steps, just take care of some points such as:

If you want, you can delete duplicate records. To delete the records, manually select the records and press delete. MS Access can delete these duplicate records automatically also but the problem is that it can be done by find duplicate wizards. The last but not the least point to take care of is you have the wizard installed on your computer. So, these are the way to check duplicate records in MS Access. We hope these instructions will be helpful for you.