How to Show or Hide Tabs in Microsoft Access 2010

Make the Ribbon Work for You

Rear view of blonde businesswoman working at computer
Microsoft Access is easy to learn. Hero Images / Getty Images

Microsoft Access 2010 provides users with an easy-to-use database management solution. Users of Microsoft products appreciate the familiar Windows look and feel and the tight integration with other Microsoft products. 

Access 2010 and newer versions use the tabbed document format—the ribbon—found in other Microsoft Office products. The ribbon replaces the toolbars and menus found in earlier versions of Access. This collection of tabs may be hidden or exposed to support specific development tasks. Here's how to show or hide the tabs in Access 2010.

  1. Click the File tab on the Ribbon.
  2. Click the Options button that appears in the bottom portion of the menu frame. Note that it's not on the main list of menu items, but appears in the bottom frame above the Exit button.
  3. Click the Current Database menu item.
  4. To hide document tabs, uncheck the "Display Document Tabs" checkbox. If you're using a database where someone hid the tabs and wish to make them reappear, check the "Display Document Tabs" box.


  1. The settings you make apply to the current database only. You need to change this setting manually for other databases.
  2. The settings apply on all computers accessing the database file.
  3. You can switch to the old-style “overlapping windows” view by selecting that option under Document Window Options on the Current Database options menu.

Other New Features in Access 2010

In addition to the ribbon, Access 2010 contains many other new or improved features:

  • Database web sharing via SharePoint
  • New database templates
  • Application Parts to add functionality to a database
  • New macro builder
  • Data macros
  • Calculated fields that display the results of a calculation
  • Enhanced Expression Builder
  • Layout view
  • Backstage view for commands that affect an entire database
  • Improved Navigation Pane
  • Field List Pane
  • Improved datasheet view