WINE stands for WINE Is Not an Emulator. It can maqke Visual Basic work in linux. A variant called WineX (now Cedega) will allow you to play most windows games (It is available from www.transgaming.com).
OpenOffice can exchange files with Microsoft Office, especially in the most modern versions. The things you will notice are no Publisher and No Front Page. Howevrer, if you get Kubuntu, then you will have Kile (better than publisher) and KWebDev (superior to FrontPage).
You won't have any worries about viruses and most other exploits won't work on Ubuntu or Kubuntu or Xubuntu.
Evolution is able to talk to Microsoft Exchange Servers and is a good replacement for the Outlook Virus Transport system.
You will NOT find any equivalent of the Access Data base, but then Access is really a toy. Postgresql, MySQL and others more than take up the slack. If you want toy databases, Kexi and OpenOffice Base are waiting in the wings.
If you care to learn to code programs, Ubuntu and its variants have MANY choices, all free. Ada, Fortran 95, Objective C, C/C++, Perl, Python, and Euphoria are some of the choices.
I do not use Ubuntu. I use several other linices, including Mandriva Power Pack which seems to work very well on my Heavy Notebooks, and gNewSense which works very well indeed on my netbook. I have used Ubuntu in embedded devices and I used Goobuntu when working for Google.
A FEW of the desktop features of Kubuntu are in Win 7, but I have some experience with Win 7 as I am forced to use it at work.
1. Win 7 loses connection to all its printers. You can send print jobs, but they don't go anywhere, until you restart, then they despool without your being able to cancel them.
2. The video driver crashes at least once a day, with the screen going black for 3-5 minutes before Win7 gets it restored. Older versions of Windows would have shown the Blue Screen of Death.
3. After I restart, the windows desktop comes up about 40 seconds after I login, but it is ANOTHER FOUR MINUTES before I can run a program. WIth KDE on Kubuntu or Mandriva, the restarts to a usable screen are less than 22 seconds.
Oh, Yes, FLUENDO sells a set of Codecs that makes your linux machine completely compatible with all Windows media.