Hi Kupe,
Microsoft really changed up Access 2007. I like to compare it to a snow globe; they really shook it up big time!
You're not alone in seeing an initial decrease in productivity. You will find yourself scratching your head trying to find where everything is for several weeks. Give it time because eventually it will sink in; trust me on that. I actually find myself becoming a little lost going back to previous versions because I'm very accustomed to the new interface now.
If you'd like some help learning where all the menu bar and toolbar commands are located in the Ribbon, I recommend you do the following:
1. Open Access 2007
2. Click the Help button in the upper right corner
3. Maximize the Help screen if it's too small to see things easier
4. In the Help Search box in the upper left corner type this in:
HA10166606
(You can copy and paste it from here if you'd like)
5. Now hit the Search button
6. Access should now list the perfect help topic you need (Result 1 of 1)
7. Click the link to read the help topic on this subject.
You'll find a link in that article to the "Access Ribbon Mapping Workbook." You'll definitely want to save this spreadsheet! You'll be able to easily see on a series of tabs where are all the commands have been moved in the Ribbon.
--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation
Co-author -
Microsoft Office Access 2007 Inside Out
Presenter -
Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info:
http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------