Microsoft Access has different types of queries to do everything from just viewing selected data to archiving it using a make table query, deleting data, appending data and updating data.

For the next few days I will be adding video tutorials on the make table, delete, append and update queries. Today the tutorial is about the make table query. I usually use this to either archive data or to extract some data so that I can work with a smaller dataset.

Using the make table query does not remove any data from the original table it just copies the data over. However, it is always a good idea to have a backup of your data.