I have around 4000 records, and I have to update a custom field (e.g Rating) in Account object, where condition is that if value in the field is 10 update/change to "A" and if the value in a field is 20 change to "B" in all the records.

what is the best way i.e SOQL or data (Data Loader), I am new to SOQL

Thank you very much 

I need help in writting a SOQL on Account (standard oject) record type ='Partner or Vendor' and pull all the records from related list Standard Object Opportuntiy and custom field 'Partner_Program_source_c' in Opportunity Object.   And also in the same query to pull all record from one more related list  custom object 'Opportunty Vendor' which has a master-detail relationship with Opportunity.

 

Recent Items Display field.
Is there anyway to change recent items display field? How to configure recent items side bar?

I have around 4000 records, and I have to update a custom field (e.g Rating) in Account object, where condition is that if value in the field is 10 update/change to "A" and if the value in a field is 20 change to "B" in all the records.

what is the best way i.e SOQL or data (Data Loader), I am new to SOQL

Thank you very much