Hi, I'm creating tables with unique values for normalization practices. At the moment, for example, I've created a table for FirstName. Column 1 is the PK set to auto number. Column 2 is FirstName, small text, no duplicates, no zero length. Reading the Access Bible, apparently, this is the normal practice. But in watching a tutorial video, the instructor has set column 1 (PK) with FirstName, Small text. No second column. So which method is best practice to save space in the design stage? So far all my unique value tables have column one (PK) with auto number while my second column also has the unique FirstNames.
Also, in Table Design View, the instructor I'm watching is setting one of the fields to data type LookUp Wizard... Instead, I'm creating a FK field and linking (in the relationships window) it to its corresponding PK table. Again, which method should be used or preferred in design practice. Thanks.