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 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. ...

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