Click New Query in the context menu. In the Query window, type a statement such as the following: SELECT client_id, first_name, last_name INTO new_table FROM old_table; GO ...

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.

SQL/XML is a small extension to SQL that allows a SQL query to create any desired XML structure. For a SQL programmer it requires little new learning, and it allows existing databases to be used ...