I'm currently using Access 2007 at my new job and they require me to help build simple DB's, run Reports, etc, etc. On my computer at home I have Access 2010, which I'm sure has some features that 2007 does. I also have some video tutorials and ebooks to help me learn Access 2010.
My questions is, will there be a huge difference between both 2007 and 2010? I only ask so that I can start teaching myself at home and able to apply what I learned at work.
No: Acc2010 is just a functional (as in having less bugs) , more elaborate version of Acc2007. You'll find the same basic functionalities in both versions. The interface did not change a lot from one version to the other either, so if you're at ease with one you'll be with the other too.