Make-table queries are used mainly for copy data to a table, archive the data, or save the results of a query, 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 registry, so it is very important to know how to implement this function.
Considering the importance and all the benefits what does this Access function, here we are going to explain a little more about it so you can start create table make 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 for in a database?
Make-table queries are considered as one of the most powerful tools in a database, and 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 consultations consist of find and collect all the information from one or more data tables so that detailed information can be obtained from the database.
When you want to execute this function, it is necessary that an aspect is defined for the search, like what is you want to find, this will allow the information you want exactly to be output. 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 tables, so it does not only perform simple searches.
This means that it allows you to perform customer table lookups To find it address of a specific client or the car model of one of them. The advantage of this tool is that it has the ability to provide information that you would not be able to obtain if you carry out the investigation examining each of the records.
Also, it should be mentioned that when a query the results appear in a table, but when it is being designed the "Query Design View", where you can carry out the data settings to perform the search.
Learn step by step how to create a table creation query in Access
At the moment of wanting create a make table query, the first thing you should do is create a select query and then you must make it a make-table query. In the case of selection queries they can use calculated fields and expressions that allow return data that are needed. In accordance with this, 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 "Create" and in the section of "Queries" you must select the option "Query design".
- Then you will see a dialog box of "Show table", there you must double click on the tables from which you want to recover data. In this case, each of the tables will appear as a window in the upper 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" of the layout grid. In the following image you can view layout grid with several fields in the table 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 criteria, then go back to run the query until it returns the data you want to place in the new table.
Convert the select query
- The next thing will be to open the select query in the view "Design" or switch to Design view, you can do this in several ways in Microsoft Access.
- In the case that the query is open in a data sheet, then you should click the button right mouse in the tab consultation documents and then in "Design View".
- Now if the query is closed, then you should go to the navigation pane, and there right click the mouse and select "Design View" in the drop-down menu.
- In the group of "Type of query" 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 "Name of the table" you must write the name of the new table, you can also select drop down arrow and select a existing name for the table.
- The next thing will be to place the new table in the active database, to do this, select it and click on "To accept".
- If the option to "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 running.
- Once you have reached this point you must place the new table in another database, to do this click on "Another database" and in the box "Filename" writes the location and file name of the other database. You can also click the option "Examine" and use the category of "Create table" to find the other database and then click the button "To accept".
- Again you must click "To accept" to close the first dialog box "Create table".
- Now click on "Run" and finally click on the option "yes" So you can confirm the process.