How to Reindex SQL Tables. ... which looks like a the right-pointing, green triangle, to execute your SQL code and list the results in a separate area beneath the code.

"SQL Performance Tuning" will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval.

A few years ago, teams had to write SQL queries and code to extract useful information from large swathes of data. Today, all they have to do is type in a question.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.