12 min read
The SQL View: Peeking Under the Hood
Every query built visually in Design View is secretly being translated into SQL — a glance at it now and then demystifies what's really happening.
Field Notes: What Design View Is Really Doing
Every query you build visually in Design View is secretly being translated into SQL (Structured Query Language), the standard language databases use behind the scenes. Go to View, then SQL View, to see this directly.
A simple query might translate into something like: SELECT CustomerName, OrderDate FROM Customers, Orders WHERE Customers.CustomerID = Orders.CustomerID;
More lessons in Microsoft Access · Next: Parameter Queries · Previous: Action Queries: Update, Append, Delete, Make-Table
