Uploaded July 2026 | Updated September 2026, 2 weeks ago
What is the main purpose of a primary key? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions to test your knowledge of primary keys, foreign keys, one-to-many relationships, AutoNumber fields, data types, relational tables, and indexed fields. Answer each question, check your score, and see how well you know Microsoft Access.
CHAPTERS:
00:00 Introduction
00:18 Primary Key Purpose
00:38 Foreign Keys in One-to-Many Relationships
01:07 Matching Foreign Key Data Types
01:30 Using IDs for Shipping Methods
02:01 Preventing Duplicate Field Values
02:25 Recommended Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Access Video Quiz X1.2: 599cd.com/VQ6
WANT MORE?:
Access Video Quizzes: 599cd.com/VQ
RECOMMENDED COURSES:
Table Relationships 2: 599cd.com/ACX01-2
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
Video Quiz, Microsoft Access, MS Access, msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #quiz, primary key, foreign key, one-to-many relationship, AutoNumber primary key, long integer foreign key, relational tables, indexed yes no duplicates, unique index, duplicate values, lookup table, shipping method ID, database normalization
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
What is the main purpose of a primary key? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions to test your knowledge of primary keys, foreign keys, one-to-many relationships, AutoNumber fields, data types, relational tables, and indexed fields. Answer each question, check your score, and see how well you know Microsoft Access.
CHAPTERS:
00:00 Introduction
00:18 Primary Key Purpose
00:38 Foreign Keys in One-to-Many Relationships
01:07 Matching Foreign Key Data Types
01:30 Using IDs for Shipping Methods
02:01 Preventing Duplicate Field Values
02:25 Recommended Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Access Video Quiz X1.2: 599cd.com/VQ6
WANT MORE?:
Access Video Quizzes: 599cd.com/VQ
RECOMMENDED COURSES:
Table Relationships 2: 599cd.com/ACX01-2
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
Video Quiz, Microsoft Access, MS Access, msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #quiz, primary key, foreign key, one-to-many relationship, AutoNumber primary key, long integer foreign key, relational tables, indexed yes no duplicates, unique index, duplicate values, lookup table, shipping method ID, database normalization
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
