• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Creating and Updating Jet Ta... > Creating New Tables with Make-Table ...

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, tblShipAddresses, for customers that have different shipping and billing addresses. This process enables the deletion of the tblShipAddresses 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're converting data contained in a flat (nonrelational) database to a relational database structure. You can use the Table Analyzer Wizard, described in Chapter 5, “Working with Jet Databases and Tables,” to perform an operation similar to that described in the following sections. Removing duplicated data manually, however, is one of the best methods of demonstrating how to design make-table queries.

→ To use a wizard to remove duplicate data, see “Using the Table Analyzer Wizard”.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint