O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Action Queries to Append Records to a Table

A make-table query creates the new table structure from the structure of the records that underlie the query. Only the fields of the records that appear in the query are added to the new table's structure. If you design and save a Shipping Address table before extracting the duplicated data from the Orders table, you can use an Append query to add the extracted data to the new table.

Another situation in which append queries are useful is when removing duplicate data from a table currently in use. In this case, you use make-table queries to create the related tables and then change them to append ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required