O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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

Normalizing in Access

Now you are ready for some hands on instruction. This should be easy and fun. Download ADBE.zip from www.QuePublishing.com. Unzip the files to a folder called AccessByExample on the C: drive. Open the Normalize.mdb database from the AccessByExample folder with the CustOrder table shown in Figure 1.10. This table will be analyzed by the Table Analyzer Wizard, which follows the principles of normalization presented in this chapter.

Figure 1.10. This is the CustOrd table that will be examined by the table analyzer.

To allow Access to automatically normalize your table for you, follow these steps:

1.
Choose Tools, Analyze ...

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