Microsoft Access Quick Queries #36: Use Dlookup Not Dcount, Query Properties, More!

In this Microsoft Access tutorial, I will show you how to efficiently check for related records using DLookup instead of DCount, discuss generating random order numbers, explain the difference between DISTINCT and DISTINCTROW in query design, demonstrate using SQL and query builders in forms and controls, offer tips for searching my website for specific topics, and answer questions about reminders for updating holidays in your database.

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Quick Queries #36: https://599cd.com/QQ36

PREREQUISITES:
Quick Queries Listing: https://599cd.com/QuickQueries
Quick Queries #35: https://599cd.com/QQ35

LINKS:
DLookup: https://599cd.com/DLookup
DCount: https://599cd.com/DCount
NZ Function: https://599cd.com/NZ
Reminder Popup: https://599cd.com/Timer
Reminder Popup Date: https://599cd.com/ReminderPopupDate
Do Records Exist: https://599cd.com/DoRecordsExist

UP NEXT:
Quick Queries #37: https://599cd.com/QQ37

RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
Access Beginner 1: https://599cd.com/ACB1

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

DIAMOND SPONSORS:
More info on our Sponsors: https://599cd.com/DiamondSponsors

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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, DCount vs DLookup, using DLookup to check related records, unique values vs unique records, DISTINCT vs DISTINCTROW, query properties sheet, aggregate queries, sequential order numbers, generating random order numbers, SQL query builder in forms, editing Row Source SQL, advanced query options, search function limitations, DLookup multiple criteria, Access Index page, database reminders for holidays, Timer event reminders, OnOpen event reminders, finding TechHelp videos, channel membership options

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