Creating and Using Action Queries - Create an Address Table from the Select Query
(Page 3 of 5 )
Open the EmployeeAddress query in design view as shown. Right click on an empty area by the side of the Employees table and click on the Make-Table Query... submenu item as shown.
This brings up the Make Table window as shown. You have the option of creating a new table in the current database, or in another database with a name you provide. Here a table called Address will be created in the current database. Type in the name Address and click on the OK button.
This brings up the Save As dialog. Save the query under a suitable name. Here it is called the AddressQuery.
Click on the OK button to the Save query. This adds the AddressQuery to the database.
The SQLView of the MakeTable query is as shown here. This is called the Select Into statement. This will dump the selected columns into a table called Address.
SELECT Employees!FirstName & " " & Employees!LastName AS Emp_Name,
Employees.Address, Employees.City, Employees.PostalCode,
Employees.Country INTO Address
FROM Employees;
When you click this query in the main window you will get a message from MS Access as shown.
When you click on the Yes button you get another message warning you about what is going to happen, and how the action is not reversible (cannot be undone).
Go ahead and click on the Yes button one more time. This will create the 'Address' table as shown in the main window of the database.
Next: Create an Append Query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 10 
