Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

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.

Click Insert in the top menu, then select Pivot table from the drop-down menu to open the Create pivot table window. Confirm the range of data you selected.