Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Table Tools -> Database Tools -> Table Analyzer Table Analyzer Options 2: Looking at the Problem The Table Analyzer determines if there are any duplicates in your table. By definition, a First Normal Form has no repeating groups.   3: Solving the Problem The Table Analyzer may recommend splitting your table to create a separate table for values that can be used in many places. By definition, a Second Normal Form has unique tables for unique data and relate those tables by their keys.   The Table Analyzer Wizard will create two new tables if you wish. The original tblMovieTitles will not be changed.