October 1997
Intermediate to advanced
1312 pages
38h 56m
English
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 ...
Read now
Unlock full access