【 Create Table Creation Query in Access 】 Guide ▷ 2022

The creation queries are mainly used for copy data into a table, archive the data, or save the results of a so it becomes a very important process to perform when working with database. Therefore this microsoft software offers you tools that will allow you work more comfortably and easily on it.

Therefore, with this option, users will have the opportunity to carry out different actions in a very simple way, such as change or update a part of the existing data in the recordso it is very important to know how to implement this function.

Considering the importance and all the benefits What does this bring? function of , Here we are going to explain a little more about it so you can start to create a make table query easily. To do this, follow in detail each of the steps that we are going to teach you next in the post.

What is a make table query and what is it used for in a database?

The make-table queries are considered one of the more powerful database toolsand it is that it has the function of quickly retrieve and analyze the data contained in the table by running a query. In these cases, the queries consist of search and collect all information from one or more data tables so that detailed information can be obtained the database.

When wanting to execute this function, it is necessary that define an aspect for the searchlike what is it you want to find, this will allow the information you exactly want to be thrown. Many of the users consider this access tool as a filter to run searches, but the truth is that this function goes much further, since it allows find information that is contained in multiple tablesso it doesn’t just perform simple searches.

This means that it allows you to perform customer table lookups To find it address of a specific client or the model of the car of one of them. The advantage of this tool is that it has the ability to provide information that you could not get if you carried out the investigation examining each of the records.

Also, it should be mentioned that when you are running a query the results appear in a tablebut when it is being designed, the “Query Design View”, where you can carry out the data configuration to carry out said search.

Learn step by step how to create a make table query in Access

at the moment of wanting create a make table querythe first thing you should do is create a select query and then you must convert it to a make table query. In the case of the selection queries they can be use calculated fields and expressions that allow return the data that are needed Accordingly, here we are going to show you in detail how you can start create and convert make table queries in Access.

To do this, follow each of the steps that we are going to teach you below:

Create the select query

• To start this procedure you must go to the Ribbon and there select the tab “To create” and in the section of “Queries” you must select the option “Query Design”.
• Then a dialog box will appear “show table”, there you must double click on the tables from which you want to retrieve data. In this case each of the tables will appear as a window in the top selection of the query design.
• Once you finish adding the tables you must click on “To close”.
• Now in each of the tables you must double click on the fields you want use in query. In this case each of the fields will appear in a blank cell of the row “Countryside” from the layout grid. In the following image you can see the layout grid with several table fields already set.

• If you want you can also add criteria to the row of “Criteria” from the layout grid.
• Then you must click on “Run” so that the query is executed teaching the results in a text sheet.
• If you want modify any of the fields, expressions or criteriathen go back to run the query until it returns the data that you want to put in the new table.

Convert the select query

• The next thing will be to open the select query in the view “Design” either switch to Design viewYou can do this in several ways in Microsoft Access.
• In the event that the consultation is open in a data sheet, then you have to click the button mouse right in the tab consultation documents and then in “Design View”.
• Now if the query is closed, then you need to go to the explore panel, and there right click on your mouse and select “Design View” in the drop down menu.
• in the group of “Query type” from the tab “Design” you will find the option of “Create table” which you are going to select.
• There you will see the dialog box “Create table”.

• In section “Table name” you must write the name of the new table, you can also select the drop down arrow and select a existing name for the table.
• The next thing will be to place the new table in the active databaseto do so, select it and click on “To accept”.
• If the option is not already selected “Active database”, then you must select it and click on “To accept”.
• Click on “Run” and then in the option “Yes” So you can confirm the action that is being executed.
• Once you have reached this point you must place the new table in another database, for this click on “Other database” and in the box “Filename” write the location and file name of the other database. You can also click on the option “Review” and use the category “Create table” to search the other database and then click the button “To accept”.
• Again you must click on “To accept” to close the first dialog box “Create table”.
• Now click “Run” and finally click on the option “Yes” So you can confirm process.