How Do You Create An Update Action Query In Access 2003?
Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003. Open Microsoft Access 2003, and then open a table or database. The “Database” window will open. Click on the “Query” tab. Click on “New.” Then click on “Design View,” and “OK.” In the “Show Table” dialog box, select the tab or tabs that contain the data you want to append. Double-click on each object you want to add to the query. Then click “Close.” Add fields to the “Field” row on the design grid. In “Design View,” click on the arrow in the “Query Type” toolbar button. Click on “Append.” The “Append” dialog box will appear. In the “Table Name” box, enter the name of the current database or another database. Select the fields you wish to use by clicking on them. Drag them to the query grid. Access will automatically append fields if the names of
