Last week was VLOOKUP Week! ... a tradition started by Bill "MrExcel" Jelen, who has a YouTube channel called BJELE123 with great videos for learning Excel. When Bill asked me to do a VLOOKUP video, I was honored as I usually make videos for Access and Windows Phone development. It was fun!
This video calculates distance between coordinates using VLOOKUP to get Latitude and Longitude from a table of Zip Codes, which is available as a free download on my website.
There is also Concatenation, Errors (of course) and how to fix them, Relative and Absolute References, Range Names, Transposing, VBA, Table Styles, Formatting, and Conditional Formatting.
Excel VLOOKUP to Calculate Distances using Latitude & Longitude, by Crystal (cc) VLOOKUP Week
http://www.youtube.com/watch?v=bc92JR2OPss&feature=BFa&list=PL7C75A052F80E19B7
Now, we build the same thing in Access ...
Import tables from another database, DLookup, DMin, Query Critera and Calculated fields, VBA, Crosstab, Report Design, Align controls, Change widths, Format numbers, Page Layout, Detail Section, change Colors based on Row.
Convert VLOOKUP equations to Access, by Crystal for VLOOKUP Week
http://www.youtube.com/watch?v=ED_Wd4w9PLk&feature=BFa&list=PL7C75A052F80E19B7
Warm Regards,
Crystal
*
(: have an awesome day :)
*
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar