Developers don't like Office 2007 because the Ribbon is so hard to program. But if you're using Access and Excel, you can hide and display the Ribbon with a bit of help from VBA.
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Ribbon", acToolbarYesMost likely, you'll hide the Ribbon when you launch the database using an AutoExec macro or startup property. You could add a custom button that shows the Ribbon or simply hide and show the Ribbon as required. Excel users can use a similarly easy set of VBA statements to hide and display the Ribbon, respectively:
How you execute the code is up to you. You can attach the hide code to ThisWorksheet's Open event to hide the Ribbon when a user opens the file. Or you might execute it when you launch a user form.