O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required