Selasa, 03 April 2012

Re: [MS_AccessPros] Re: VLOOKUP Week videos -- how to do it in Excel ... and in Access

 

Hi Bill,

thank you :)

I did this video twice -- first time I used the wrong resolution to record, grrr! Did not figure that out till I was mixing the audio (which the first time was done separately to match the video so I redid that too). Then I recorded everything again and did audio and video in one pass ... hard to do that and follow a script so  my first query was done differently.  Running the query was slower the second time (I cut the processing time from the video).  I have been wondering why ... I think I know -- the query performance of qAirportsNY will be faster with an outer join ... have to test this -- and if true, maybe I'll make another video about it :)

> "sample DB"

not yet ... because of the above issue ... all the steps are there though :) 

Warm Regards,
Crystal

Learn Access on YouTube
http://www.YouTube.com/LearnAccessByCrystal

 *
   (: have an awesome day :)
 *

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, April 3, 2012 2:10 PM
Subject: [MS_AccessPros] Re: VLOOKUP Week videos -- how to do it in Excel ... and in Access

Hi Crystal

Great video with a good example of Cartesian result sets. Where can we get your code? Did you upload a sample DB?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
>
> 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]
>

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar