Sign into this computer using your Microsoft account

Thanks for the reply Andre,

So I just ran the troubleshoot and it appears that there were two errors which sound like they could be related to the account sync issues that I've been having. I should also mention that I noticed this issue 2-4 weeks now and have performed several reboots and troubleshooting on the account since then. To me, the issue appears to be a setting or something related to the PC itself and not the account right? 

Can't connect to the sync service & Root causes found and created logs

It appears that I'm already signed into my Local Account as Administrator, therefore the option to sign in with a local account isn't there. Only the option to Sign in with a Microsoft account instead.

Are there any other account settings that I can look at? 

Okay, so I finally managed to solve this problem which the resolution was very weird in my opinion. Before I attempted to use the net user command that you provided I restarted the PC and instead of logging in using my PIN, I switched the setting to use Password, I used my Microsoft account password that I normally use which is all lowercase but it then hinted that one letter is uppercase therefore I applied the change and it logged me in successfully. 

Apparently, from what I can tell on Settings>Your info>Login to Microsoft account, on the first prompt for the password I entered all lowercase which it accepts without issue, then on the second prompt which states enter password "one last time" I entered it with an uppercase and it finally accepted. Perhaps the wording or something threw me off or do you agree that this is some kind of glitch?

Thanks for all of your help!!