Creating and Using Action Queries - Create an Append Query
(Page 4 of 5 )
Appending records to a table can be useful in some cases when you want to just add some new records to a table. Assume that a group of Employees joined from another company which was acquired and you want to append the employee addresses of the acquired company to the existing addresses. In this situation, you may want to just append the information. This is a better way of adding the data than typing all the new information into your Address table.
The address information from your acquired business is in the AcqBusiness table as shown. You want to append the information to your Address table.
The Append query
Click on "create a query" in the design view and add the table to the design pane as shown in the next picture. Select all the required fields as shown. Right click and choose Query Type from the drop-down menu. From the next drop-down menu choose Append Query... as shown.
This brings up the next window, which is Append, as shown. Now you are appending the result of the above query to the Address table in the current database if you accept the default choice. If you want you could choose to append the results to a table in another database.
When you click on the OK button to the above screen you will be asked to save the query by giving it a name. This query was saved as AppendAcqQuery in this tutorial. This picture also shows the other queries created in this tutorial. Notice the different icons for the various queries.
The SQL View of the AppendAcqQuery is shown in the next paragraph.
INSERT INTO Address
( Emp_Name, Address, City, PostalCode, Country )
SELECT AcqBusiness.Emp_Name, AcqBusiness.Address,
AcqBusiness.City, AcqBusiness.PostalCode,
AcqBusiness.Country
FROM AcqBusiness;
Next: Appending the Records >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
