I need an example of the following (OneDrive authentication and sign-in) using VBA languge will used in Microsoft Access2013 File -or Microsoft access 2016 file
I think you are going to really struggle to achieve this from VBA. You would need to use a XmlHttpRequest library to make the HTTP calls to do the OAuth2 login flow. That's not going to be easy.
What you might be easier is to create a VB.NET or C# application that calls OneDrive and then using an ODBC/OLEDB provider to write to the Access file. It just depends what you are trying to do whether this would be a suitable approach.