Are you sure that software won't run on Windows 7 or 8? It seems like there are an awful lot of people who just assume this or that program won't work, but never actually test it or even bother taking 30 seconds to google the program name combined with the version of Windows they're interested in. So if by Office 10 you mean Office 2010, that would most definitely work on Windows 7 and 8, and I suppose it would depend on the version of Adobe Master Collection, but a quick check with Google shows that Adobe didn't start shipping anything under the "Master Collection" moniker until at least July of 2007, so that puts it about 6 or so months after Vista was released to the general public and pretty much guarantees that Adobe made sure it would work with Vista. Since Windows 7 and 8 are both basically warmed over versions of Vista, if it works with Vista it all but guarantees it would work with Windows 7 and 8.
If you're using some older version of Office, you could give LibreOffice a whirl to see if it's database program could import your Access program and basically allow you to use it more or less unmodified. It's not guaranteed obviously, but only having to replace MS Office would be a considerably more palatable proposition compared to Master Collection. That would be only about $250 to get the version with Access, or you could potentially save some more money by just getting Access 2013 alone and using LibreOffice for everything else. MS Office is better, but LibreOffice is more than capable for 99% or more of people's needs I'd say. Most people don't really need anything beyond what WordPad is capable of as far as a word processor goes. Frankly the world would probably be a better place with a significant drop in the number of people using PowerPoint and also if people would stop treating Excel like a database or desktop publishing program.