Uploaded October 2026 | Updated November 2026, 1 day ago
In this lesson, we will explore the Microsoft Access Expression Builder and learn how it helps you create expressions without memorizing every function or object name. We will walk through building a calculated query field for a line total using Quantity and Unit Price, and create query criteria that references a control on an open form. We will also discuss where to open the Expression Builder, how to browse functions, fields, forms, and operators, and why checking your results is important.
Nina from Halifax, Nova Scotia (a Gold Member) asks What is the Expression Builder for, and when should I use it instead of typing the expression myself?
CHAPTERS:
00:00 Introduction
01:17 Prerequisites
01:41 What Is An Expression?
02:29 Why Use The Expression Builder?
03:27 Opening The Expression Builder
04:36 Navigating The Expression Builder
06:26 Calculating A Query Line Total
11:58 Referencing A Control On An Open Form
15:00 Other Uses For Expressions
16:38 Conclusion
17:29 Recommended Videos And Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Expression Builder: 599cd.com/ExpressionBuilder
PREREQUISITES:
What Is a Query?: 599cd.com/Query
Calculated Fields: 599cd.com/Calculated
Query Criteria: 599cd.com/Criteria
What Is a Form?: 599cd.com/Form
What Is a Report?: 599cd.com/Report
LINKS:
Concatenation: 599cd.com/Concat
IIF Function: 599cd.com/IIF
NZ Function: 599cd.com/NZ
DateAdd: 599cd.com/DateAdd
Format: 599cd.com/Format
Validation Rules: 599cd.com/Validation
RECOMMENDED COURSES:
Access Beginner Level 5: 599cd.com/ACB5
Access Expert Level 8: 599cd.com/ACX8
Access Beginner Level 3: 599cd.com/ACB3
Access Expert Level 25: 599cd.com/ACX25
Access Expert Level 28: 599cd.com/ACX28
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, Access Expression Builder, calculated fields in queries, query criteria from open form, form control reference, calculated query field, line total calculation, Access expressions, Access query design, Control-F2, built-in functions, expression syntax
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we will explore the Microsoft Access Expression Builder and learn how it helps you create expressions without memorizing every function or object name. We will walk through building a calculated query field for a line total using Quantity and Unit Price, and create query criteria that references a control on an open form. We will also discuss where to open the Expression Builder, how to browse functions, fields, forms, and operators, and why checking your results is important.
Nina from Halifax, Nova Scotia (a Gold Member) asks What is the Expression Builder for, and when should I use it instead of typing the expression myself?
CHAPTERS:
00:00 Introduction
01:17 Prerequisites
01:41 What Is An Expression?
02:29 Why Use The Expression Builder?
03:27 Opening The Expression Builder
04:36 Navigating The Expression Builder
06:26 Calculating A Query Line Total
11:58 Referencing A Control On An Open Form
15:00 Other Uses For Expressions
16:38 Conclusion
17:29 Recommended Videos And Courses
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Expression Builder: 599cd.com/ExpressionBuilder
PREREQUISITES:
What Is a Query?: 599cd.com/Query
Calculated Fields: 599cd.com/Calculated
Query Criteria: 599cd.com/Criteria
What Is a Form?: 599cd.com/Form
What Is a Report?: 599cd.com/Report
LINKS:
Concatenation: 599cd.com/Concat
IIF Function: 599cd.com/IIF
NZ Function: 599cd.com/NZ
DateAdd: 599cd.com/DateAdd
Format: 599cd.com/Format
Validation Rules: 599cd.com/Validation
RECOMMENDED COURSES:
Access Beginner Level 5: 599cd.com/ACB5
Access Expert Level 8: 599cd.com/ACX8
Access Beginner Level 3: 599cd.com/ACB3
Access Expert Level 25: 599cd.com/ACX25
Access Expert Level 28: 599cd.com/ACX28
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, Access Expression Builder, calculated fields in queries, query criteria from open form, form control reference, calculated query field, line total calculation, Access expressions, Access query design, Control-F2, built-in functions, expression syntax
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.










