Restored database from .bkp file in SQL Server 2014 generates some strange errors
The errors have nothing to do with the fact that the database is restored (in fact they aren't even errors, just intellisense being flaky).

As you can see in the dropdown top left and the status bar (in yellow) you are executing your query against the master database.

Either change your database in the dropdown or execute a USE mydatabasename;.

As noted by Aaron Ctrl-shift-R refreshes the intellisense but that could take a while before taking effect.