Question

Q.4. Explain select and find duplicate record queries.​

Answer 1

Answer:

Find duplicate records

To find duplicate records using the Query Wizard, follow these steps.

On the Create tab, in the Queries group, click Query Wizard.

In the New Query dialog, click Find Duplicates Query Wizard > OK.

In the list of tables, select the table you want to use and click Next.

Select the fields that you want to match and click Next.

In the list of available fields, select the field or fields that contain the data that you want to update and click Next.

Accept the suggested query name or enter a name, and click Finish to run the query.

After you locate duplicate records, you can either edit or Delete duplicate records with a query.

To locate duplicate records from multiple tables, create a union query.