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 ... |
Get Access 2002 Programming by Example 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.
