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.
To allow Access to automatically normalize your table for you, follow these steps:
Choose Tools, Analyze ...