Uploaded October 2026 | Updated November 2026, 2 days ago
In this lesson, we will prevent duplicate pairs in Microsoft Access by creating a unique multi-field index. I will show you how to keep an AutoNumber primary key while enforcing a rule that prevents the same customer and class combination from being entered twice. We will also discuss common indexing mistakes, required fields, existing duplicate data, and how to determine which fields belong in a composite key.
Maya from Cedar Falls, Iowa (a Gold Member) asks How can I prevent the same employee from being registered for the same training session twice without blocking legitimate registrations?
CHAPTERS:
00:00 Introduction
00:44 The Duplicate Registration Problem
01:12 Unique Multi-Field Indexes
02:09 Example Duplicate Combinations
03:14 Common Indexing Mistakes
04:24 Three-Field Composite Keys
05:03 Preparing Existing Data
05:40 Prerequisites
06:02 Access Demonstration
06:54 Creating The Registration Table
08:16 Creating A Unique Composite Index
09:19 Testing Duplicate Prevention
10:10 Conclusion
10:41 Recommended Videos
11:07 Recommended Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Duplicate Pairs: 599cd.com/DuplicatePairs
PREREQUISITES:
Indexing: 599cd.com/Indexing
LINKS:
Find Duplicates: 599cd.com/2598
Duplicate Check Numbers: 599cd.com/3799
RECOMMENDED COURSES:
Access Beginner Level 4: 599cd.com/ACB4
Access Developer Level 36: 599cd.com/ACD36
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
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
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, composite key Access, unique multi-field index, prevent duplicate combinations, unique index multiple fields, AutoNumber primary key, indexed no duplicates, required fields, Find Duplicates query, custom duplicate error message
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will prevent duplicate pairs in Microsoft Access by creating a unique multi-field index. I will show you how to keep an AutoNumber primary key while enforcing a rule that prevents the same customer and class combination from being entered twice. We will also discuss common indexing mistakes, required fields, existing duplicate data, and how to determine which fields belong in a composite key.
Maya from Cedar Falls, Iowa (a Gold Member) asks How can I prevent the same employee from being registered for the same training session twice without blocking legitimate registrations?
CHAPTERS:
00:00 Introduction
00:44 The Duplicate Registration Problem
01:12 Unique Multi-Field Indexes
02:09 Example Duplicate Combinations
03:14 Common Indexing Mistakes
04:24 Three-Field Composite Keys
05:03 Preparing Existing Data
05:40 Prerequisites
06:02 Access Demonstration
06:54 Creating The Registration Table
08:16 Creating A Unique Composite Index
09:19 Testing Duplicate Prevention
10:10 Conclusion
10:41 Recommended Videos
11:07 Recommended Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Duplicate Pairs: 599cd.com/DuplicatePairs
PREREQUISITES:
Indexing: 599cd.com/Indexing
LINKS:
Find Duplicates: 599cd.com/2598
Duplicate Check Numbers: 599cd.com/3799
RECOMMENDED COURSES:
Access Beginner Level 4: 599cd.com/ACB4
Access Developer Level 36: 599cd.com/ACD36
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
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
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, composite key Access, unique multi-field index, prevent duplicate combinations, unique index multiple fields, AutoNumber primary key, indexed no duplicates, required fields, Find Duplicates query, custom duplicate error message
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.










