A discover copies inquiry enables you to scan for and recognize copy records inside a table or tables. A copy record is a record that alludes to an indistinguishable thing or individual from another record.
To create a find duplicates query:
- Select the Create tab on the Ribbon, find the Queries gathering, and tap the Query Wizard order.
- The New Query discourse box will show up. Select Find Duplicates Query Wizard from the rundown of inquiries, at that point click OK.
- Select the table you need to scan for copy records, at that point click Next. We’re looking for copy client records, so we’ll choose the Customers table.
- Choose the fields you want to search for duplicate information by selecting them and then clicking the right arrow button. Only select fields that should not be identical in nonduplicate records. For instance, because we’re searching for duplicate customers we’ll only select the First Name and Last Name fields because it’s unlikely that multiple people with the exact same first and last names would place orders at our bakery.
- When you’ve added the desired fields, click Next.
- Select extra fields to see in the inquiry comes about. Pick handle that will enable you to recognize the copy records, and pick which one you need to keep. In our case, we’ll include the majority of the fields identifying with client addresses, in addition to the Phone Number field since records with indistinguishable client names may contain nonidentical data in this field. When you’re fulfilled, click Next.
- Access will propose a name for your question, yet you can type an alternate name on the off chance that you need. When you’re happy with the inquiry name, click Finish to run your question.
- On the off chance that Access found any copy records in your question, they will be shown in the inquiry comes about. Survey the records and erase any obsolete or wrong records as required.
Read More Post At Office Com Setup