USING SELECT QUERIES: POWER IN THE QUERY DESIGN GRID
Access developers must learn the query design grid and learn it well. After you learn it, it becomes a valuable tool with which you can build applications quickly and get a jump on the development process.
The query design grid in Query Design view is the fastest way to get a query going, and to see visually that you're selecting and sorting on the right fields. However, Query Design view also has the SQL view window for accessing the SQL statement directly, as well as the datasheet view for testing.
For Select queries, you can update data right in the grid without programming.
The folks who say, “Real programmers don't use the query design grid. They use SQL,” have way too much time on their ...
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
