In this video, I'll show you how to perform the equivalent of the VLOOKUP function from Excel in Microsoft Access using DMax and DLookup. We will look up letter grades for students based on their test scores.
Alyssa from Baltimore, Maryland (a Gold Member) asks: I know how to use the VLOOKUP function in Excel to figure out letter grades from test scores. How can I do the same thing in Access?
BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a GetLetterGrade global function so this lookup can be performed anywhere in the database without extra steps.
MEMBERS VIDEO:
• Microsoft Access Equiv...
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/VLookupInAccess
LINKS:
Excel VLOOKUP Function: 599cd.com/VLOOKUP
Excel Expert 4: 599cd.com/XLX4
DLookup: 599cd.com/DLookup
DMax: 599cd.com/DMax
Access Expert 29: 599cd.com/ACX29
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/Consulting
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, Access Equivalent of Excel VLookup, Excel-Like VLookup for Microsoft Access, Can I do VLookup in access, How to do a VLookup in access, dlookup, vlookup, dmax
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет Microsoft Access Equivalent of an Excel VLOOKUP Function with Approximate Match using DLookup, DMax
Пікірлер: 33