Creating New Tables with Make-Table Queries
In the following sections, you learn how to use a make-table query to create a new table, Shipping Address, for customers that have different shipping and billing addresses. This process enables the deletion of the shipping address data that, in most of the records in the Orders table, duplicates the address data in the Customers table. Removing duplicated data to new tables is an important step when you are converting data contained in a flat (non-relational) database to a relational database structure. You can use the Table Analyzer Wizard, described in Chapter 22, "Exploring Relational Database Design and Implementation," to perform an operation similar to that described in the following sections. ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
