Microsoft Access 2016 Tables: Lookup Data Field

Microsoft Access 2016 training video on how to use the Lookup Field to lookup the details of entered data, or to actually enter in data from a list of options for more accurate data entry.
All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and become certified!
DVD & DOWNLOAD AVAILABLE:
www.DreamForce.us
SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
th-cam.com/users/subscription_c...
LET'S CONNECT!
-- / kirt-kershaw-33874410

[@wesluckey230]

These short videos are some of the best for training on Access 2016. And they are short and to the point. Very helpful.

[@denysuhendraproject5251]

Thank you for the tutorial, I use it as student project

[@tanjacky5780]

It is very useful when the database is complex! Thumbs up!

[@KirtKershaw]

Thank you 😊

[@melmorsen]

thank you for your videos! you do a great job explaining!!

[@KirtKershaw]

Welcome and thank you 🙂

[@kcwong6781]

You explain clearly! Thank you for sharing.

[@KirtKershaw]

Welcome 😊

[@CherGarcia]

Great and entertaining explanation! I learned a lot!

[@KirtKershaw]

Thank you 😊

[@mahmudulislam2833]

Very good job man. Thumbs up and Thanks

[@KirtKershaw]

Welcome 😊

[@gochocitizen]

Awesome. Great trainer. I’m subscribed now.

[@KirtKershaw]

Thank you 😊

[@micahdavis9067]

Thanks, man this is great!
Here's a question, is it possible to have the additional columns in the combo box actually appear as full editable columns themselves?
I'd like several columns containing royalty information to be pulled from a contracts table to the main table based on the contract #.
To see more than 1 column now I have to open the combo box and I can't edit or filter them.
When I try to do several lookup fields they are not connected to each other and I have to look each up individually.
I Would greatly appreciate your insight,
Thanks!

[@hemantkulharia3907]

How to get that first coloum with + sign , does help to store serial no wise entry in same id

[@moodkn]

Thanks Sir!

[@magedelgendy8193]

I still can type in something that is not on the list and access will acept that input. How can we limit the inputs to the list elements only?

[@lloydderss1961]

This is so helpful

[@KirtKershaw]

Thank you 😊

[@ghostface9554]

Hey how would you; under department tab display both the department code and department name

[@mannyfilmsinc]

I really enjoy your video, Oh.. that's nifty... haha, very entertaining...!!!

[@KirtKershaw]

Thank you 😊

[@creepymcpeepers]

This is not helping me