Is it possible to filter both duplicates and similar entries in MS Access?

Answer 1

Yes. If you write.a query for e.g.

select student_name, count(*)

from student_table

This will give you list of all students along with how many times their name appears. But, if you only want to see students who appeared more than. once try this.

select student_name, count(*)

from student_table

having count(*) > 1