How to Create a Make-Table Action Query in Microsoft Access

Video Transcript

"Hello my name is Chip Browne. I teach computer programming and Microsoft applications at a local business college, Stevens Henagar here in Utah. I also create practice tests for Microsoft Office applications and certifications. Today we are going to learn how to create a make table action query in Microsoft Office Access 2007. Microsoft Access is the registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. The make table action query is based upon the select into statement in SQL. The syntax of the select into statement is the select followed by the field you want to put into the new table followed by the key word into and the name of the new table, whether or not it is in the external database and from the source which is the source table. Let's create one. Click on the create tab, in the other group click the query design, choose the table from which you will select records, choose the make table, query type, give the name of the table you want to create, select the fields you want to be part of your query, next enter the criteria and now let's go look at the SQL. Here is the syntax to the SQL click on the home tab, view button, SQL. Select, followed by the fields that would be added to the new table, the into key word, the name of the new table, the table to be selected from followed by the criteria which is optional. Let's run this query. Now let's go look at the table that was created. This is the new table that was created from that select query. This is how to create make table action query from scratch. For more information visit me, chipbrowne.com."