(cant believe someone hasn't asked this but I couldn't find anything on here)
Trying to understand what a "View" is and how it differs from a Query, I have tried google and the answer I got was beyond my ability to understand.
I get that Views are stored in SQL Server, and Queries are kept local in Access but beyond that I couldn't understand the value of one over the other.
hoping someone can give me an answer that is easier to understand than the one below.
Thanks