Uploaded August 2026 | Updated September 2026, 2 weeks ago

---

What does an inner join in an Access query normally return? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions covering foreign keys, inner and left joins, related table data, and parameter prompts. Answer each question, check your score, and see how well you know Microsoft Access.

CHAPTERS:
00:00 Introduction
00:19 Foreign Key Purpose
00:44 Inner Join Results
01:10 Left Join for All Customers
01:41 Displaying Related Table Data
02:15 Enter Parameter Value Errors
02:46 Quiz Results
03:01 Recommended Courses

BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember

LEARN MORE:
Access Video Quiz X1.3: 599cd.com/VQ10

WANT MORE?:
Access Video Quizzes: 599cd.com/VQ

RECOMMENDED COURSES:
Access Expert 1, Lesson 3: 599cd.com/4644

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, Access relational queries, foreign key, inner join, left join, Enter Parameter Value prompt, unmatched records, customer orders query, query field name error, join types

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.