We are going on a deep dive to the foundation of data structure -- what is in the design view of a table? What else you can do? Use a Unique Index to prevent duplicate values from being added. We discuss Ignore Nulls, the Primary Key, AutoNumber and its properties, create a Calculated field with an Expression to combine data from other fields, tracking fields for when records were added and edited, Field Names, reserved words, and tips for naming fields, and field properties like Data Type, and Size.
Here are the other videos in this series:
Shuffle - 1 - Examine Data (imported from Excel)
https://www.experts-exchange.com/videos/61034/Shuffle-1-Examine-Data-imported-from-Excel.html
Shuffle - 2 - Totals Query
https://www.experts-exchange.com/videos/61035/Shuffle-2-Totals-Query.html
Shuffle - 4 - Append Query
https://www.experts-exchange.com/videos/61037/Shuffle-4-Append-Query.html
Look up Problem names and reserved words in Access, by Allen Browne:
http://allenbrowne.com/AppIssueBadWord.html