Yes, someone needs to have either a Microsoft Account (Free account) or Work/School account to be able to access a SharePoint site. However, if the external user does not have a Microsoft account, they will need to create one to access the SharePoint site.