Рет қаралды 10,089
I hear a lot of criticisms and arguments against using AutoNumbers as the primary key field in Microsoft Access databases. In this video, I will examine exactly what AutoNumbers are, when they should be used, when you might not want to use them, what those arguments against them are, and of course, my counters to those arguments.
Craig asks, "I’m taking a college course and the instructor gave us a homework assignment. He wants us to create a table to store vehicles where the Primary Key is the VIN. I thought you said to always use AutoNumbers. Who’s right here?"
TOPICS COVERED
- What is a Key Field
- What is a Primary Key Field
- Primary and Foreign Key Fields
- Types of Keys: Natural vs. Synthetic (Surrogate)
- What is an AutoNumber
- Why Use AutoNumbers
- When NOT To Use AutoNumbers
- The German Tank Problem
- Arguments Against AutoNumbers (and my counters)
- Random AutoNumbers and GUIDs
CONCLUSION
AutoNumbers are easier to use than natural keys or text. Access maintains them automatically and they provide a more stable database than Natural Keys. Generally, AutoNumbers save disk space and increase database performance. They decrease total cost of ownership. Other options are available to provide the user with visible identifiers for records, such as order numbers, so as not to give up business intelligence, however an Autonumber should be the primary key for MOST tables you build, with few exceptions.
SIDE VIDEOS
Create Your Own Customer Code: • Create Custom Microsof...
Sequential Numbers for Invoices: • Microsoft Access Creat...
Random AutoNumbers to Sync Remote Databases: • How to Sync Up a Remot...
Restore Lost or Deleted AutoNumbers - • Microsoft Access How t...
RESOURCES & REFERENCES
en.wikipedia.org/wiki/Surroga...
stackoverflow.com/questions/2...
en.wikipedia.org/wiki/German_...
access.mvps.org/access/tencomm...
www.fmsinc.com/MicrosoftAcces...
en.wikipedia.org/wiki/Univers...
www.fmsinc.com/free/newtips/P...
en.wikipedia.org/wiki/Christo...
www.amazon.com/Relational-Dat...
www.agiledata.org/essays/keys....
answers.microsoft.com/en-us/m...
en.wikipedia.org/wiki/Univers...
www.sqlservercentral.com/arti...
FURTHER LEARNING
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free101
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/TechHelp
Learning Connection 50% OFF: 599cd.com/Connection
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/AccessForum
Twitter: / learningaccess
Email Me: amicron@gmail.com
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...