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.

We have a large DB in production that has over 190Million records. Its 2005 SQL, and in the past i just exported the records to Excel. But this is way more then i have done before.