The VB in Access is VBA - that is "Visual Basic for Applications". You can also buy Visual Basic itself and use that as a programming language. The difference is that VBA is intended for that specific application, such as Access (I think some of the other office applications use VBA as well). You don't need version 6.0 of Visual Basic to program in VB, but prior versions don't have as much functionality, and I'm not sure you can even purchase anything prior to 6.0. You would use Visual Basic to make stand-alone programs for the desktop environment (.exe executable files) or even .dll's for either desktop or as COM (Component Object Model) components for use with desktop applications or even web pages.
Now, after that brief introduction, let's look at what you want to do. For intranet pages that interact with your Access database, you would create Active Server Pages, probably utilizing VBScript as the underlying language for all the dynamic portions of the page, and you would use ADO (ActiveX Data Objects) to access your database. I think what you need are some good websites to help you learn the basics of ASP (which is not a language in itself - just the type of page produced) so that you can make a data-driven Intranet.
(get rid of any spaces that show up in the following URL's)
http://www.learnasp.com/learnasp/
http://www.aspfaqs.com/aspfaqs/
http://www.asp101.com/
http://www.aspalliance.com/default.aspx
Hang in there! It's a little awkward at first, but you should be able to do the basics in no time. Let me know if you have further questions or problems.
