Microsoft Access: How to Use Make Table Query

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.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Microsoft Access, Office 2010 and tagged , , , , , , . Bookmark the permalink.

One Response to Microsoft Access: How to Use Make Table Query

  1. Pingback: Microsoft Access: How to Use the Delete Query | Gary Schwartz's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s