Need the first or last day of a month? Let DateSerial do the work. Day 1 gives you the start of the month. Day 0 of the next month takes you back to the last day of this one, even in February. Watch the video for the query calculations and the previous and next month variations. 599cd.com/2442

What are you looking up, where is it stored, and which record do you want? DLookup brings back one value from a table or query. This example retrieves a sales rep's phone number using a unique ID. Watch the video to see how to display the phone number for the rep selected on your form. 599cd.com/DLookup

Ever join two tables and wonder where some of your customers went? An INNER JOIN only shows customers who have a matching contact. A LEFT JOIN keeps every customer, even when there's no related contact to display. Keep this side-by-side example handy, then watch my Outer Joins video to see how to change the join in Access and bring those missing customers back. 599cd.com/OuterJoin

Your subform is showing the wrong records, and the culprit may be hiding in plain sight. Think you can go 5 for 5 on Access subforms? #msaccess youtu.be/4rQBG2r8M6c

One customer can take several courses, and each course can have several customers. That's where a junction table comes in. Give each customer-course pairing its own row, and store the enrollment and certification dates that belong to that pairing there. Watch my Many-to-Many video to see how two one-to-many relationships connect the whole thing in Access. 599cd.com/blog/display-artic…

Too many versions of the same Access query? There is a way to make the database build the exact one it needs. Seriously. #msaccess youtu.be/uTmMVI8ztlY

Nothing says "automation" like babysitting logins, reconnecting accounts, and wondering if yesterday's balance is still yesterday's. I tried making Tiller feed my Access database for 8 months. It got weird. #msaccess youtu.be/ZzBJFBHh7_s

Tiny Access trap: can you delete a label without nuking the text box attached to it? Most people guess wrong the first time. Try the forms quiz. #msaccess youtu.be/jw7MDwpw7Mo

Fraud protection that blocks a real customer with a valid card, perfect info, and front-row seats? That's not security. That's a very expensive "no." youtu.be/T6uX1S9zjuU

Access Expression Builder looks like a wall of random buttons... until you need one value from an open form. Then things get interesting. #msaccess youtu.be/B0-gzmKTOg4

Tiny VBA mistake. Completely believable data. Can you spot the Access SQL INSERT bug before it logs the wrong Martian payroll? #msaccess youtu.be/cAz5UDr-Cc0

"Access was the worst database"? That take skips one inconvenient question: what were businesses actually trying to build? #msaccess youtu.be/Fd7vrYtSm1A

Still copying the same Access code into every database? There is a better way, and updating it doesn't have to be a manual disaster. #msaccess youtu.be/C2yDj7Bcc9Y

Works in queries. Works in forms. Then Access suddenly claims it has never heard of it. Table validation rules have some weird limits. #msaccess youtu.be/SLo7utT12ik

Paid orders should be locked down. But can users still copy what they need? This Access quiz has a few gotchas. #msaccess youtu.be/dL91IYR3ItM

Your giant monitor has been mocking your tiny Access dashboard for years. That may have just changed. #msaccess youtu.be/lzbxhkbrfVw

More Wi-Fi should mean better Wi-Fi, right? Mine turned into a smart-home mutiny. Cameras offline. Alexa confused. And the culprit was not what I expected. #WiFi youtu.be/OQ2_Vji_YgA

Hidden doesn't always mean gone. What really happens when you hide a bound Customer ID field in Access? Most people guess wrong. #msaccess youtu.be/Vf-HqoBo5mQ

AI built your Access database. It runs. No errors. So you're good, right? There's a question worth asking before you trust it with your business. #msaccess youtu.be/wEDUrEUDFvg

Your AutoNumber is unique. Your data can still be wrong. How does the same employee end up in the same class twice, and why do "no duplicates" settings block valid records too? #msaccess youtu.be/9otVJT2A7xA