Removing duplicate records and retain original

[90405]

I would appreciate if anyone could suggest a method to remove duplicate records, I am still a bit of a nove and still would appreciate a simple as possible method.

But essentially, the company can have similar:
product sectors
provincial locations
telephone numbers

I would also be interested in associating a unique numeric code and not the auto nuymber if possible?

If you like I could send you the excel file to give you a better understanding.


AlmasPelliSasDiMassaroAlessandroC
AlmasPelliSasDiMassaroAlessandroEC
AlmasPelliSasDiMassaroAlessandroEC
AlmasPelliSasDiMassaroAlessandroEC

ApisSRL
ApisSrl
ApisSrl
ApisSrl
ApisSrl


AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
AIPASpaAgenziaItalianaPerPubblicheAmministrazioni
AIPASpaAgenziaItalianaPerPubblicheAmministrazioni

AFiorDiPelle
AFiorDiPelle
AFiorDiPelleDiReginatoSonia
AFiorDiPelleDiReginatoSonia

3PRappresentanzaCommercioEsteroSRL
3PRappresentanzaCommercioEsteroSRL
3PRappresentanzeCommercioEsteroSrl

ConfartDiTosanaPAECSAS
ConfartDiTosanaPAECSAS
ConfartDiTosanaPAECSAS
ConfartDiTosanaPAECSAS
ConfartDiTosanaPierachilleECSAS
ConfartDiTosanaPierachilleECSAS

 

[90405]

Could you explain the application of the autonumber and primary key as I am a novice and I am getting a bit confused trying to understand and distinguish the advantages and disadvantages, i.e. if I should let access assign an automatic autonumber or otherwise create an autonumber perhaps derived from the company name and then assign this as the primary key?