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.

You can edit values from teh parent table on this page, but you can't edit the values from a child table. By selecting the company category from the repeat region, you are taken to the ...