This Special Topic is all about duplicates in an Access database. When using a database intensively and especially with multiple users, sooner or later double records will appear, so-called duplicates. The fewer duplicates contained in a database, the more reliable and efficient a database operates. Access provides several ways to track duplicates, delete them and if needed temporarily hide them. In this Special Topic we show you how to do this.
To acces the videos for this Special Topic you must have subscribed to Access !
Access 2016
Find Duplicates:
In this video we will show you how to easily find identical data sets by using a wizard.
(4 Min.)
Hide Duplicates:
In this film we will show you how to avoid the display of duplicates in queries.
(2 Min.)
Access 2013
Find Duplicates:
In this video we will show you how to easily find identical data sets by using a wizard.
(4 Min.)
Hide Duplicates:
In this film we will show you how to avoid the display of duplicates in queries.
(2 Min.)
Access 2010
Find Duplicates:
In this video we will show you how to easily find identical data sets by using a wizard.
(4 Min.)
Hide Duplicates:
In this film we will show you how to avoid the display of duplicates in queries.
(2 Min.)
Access 2007
Find Duplicates:
In this video we will show you how to easily find identical data sets using a wizard.
(3 Min.)
Hide Duplicates:
We will show you in the film how to avoid the display of duplicates in queries.
(2 Min.)